使用视图取出用户，功能，角色，用户角色，角色功能5张表的关系

CREATE VIEW dbo.View_Login
AS
SELECT dbo.ccss_function.function_code, dbo.ccss_function.function_cn,
dbo.ccss_group.Group_cn, dbo.ccss_group.Group_code, dbo.ccss_user.User_code,
dbo.ccss_user.User_cn, dbo.ccss_user.User_en, dbo.ccss_group.Group_en,
dbo.ccss_function.function_en, dbo.ccss_function.Function_jb,
dbo.ccss_function.Function_sj_code, dbo.ccss_function.oder,
dbo.ccss_function.class, dbo.ccss_function.id AS function_id
FROM dbo.authority INNER JOIN
dbo.ccss_function ON
dbo.authority.function_code = dbo.ccss_function.function_code INNER JOIN
dbo.ccss_group ON
dbo.authority.group_code = dbo.ccss_group.Group_code INNER JOIN
dbo.user_group ON
dbo.ccss_group.Group_code = dbo.user_group.group_code INNER JOIN
dbo.ccss_user ON dbo.user_group.user_code = dbo.ccss_user.User_code

authority 角色功能表 user_group 用户角色表

function 功能表 group角色表 user 用户表

版权声明：本文为博主原创文章，未经博主允许不得转载。