Use the view to retrieve the relationships between users, functions, roles, user roles, and role functions.

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 role table user_group User Role table

Function table group role table User table