• Home
• com.jalalkiswani
• smart-desktop
• 0.0.8
• source code
• sec_user_role_privileges2.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

resources.sql.sec_user_role_privileges2.sql Maven / Gradle / Ivy

SELECT DISTINCT
sec_roles.role_id,
sec_users.user_full_name,
sec_roles.role_name,
sec_privileges.privilege_desc
FROM
sec_user_roles
Inner Join sec_roles ON sec_user_roles.role_id = sec_roles.role_id
Inner Join sec_users ON sec_user_roles.user_id = sec_users.user_record_id
Inner Join sec_role_privileges ON sec_role_privileges.role_id = sec_roles.role_id
Inner Join sec_privileges ON sec_role_privileges.privilege_id = sec_privileges.privilege_id
WHERE sec_users.user_record_id >0 
ORDER BY
sec_users.user_full_name ASC,
sec_roles.role_name ASC