• Home
• com.jalalkiswani
• smart-desktop
• 0.0.8
• source code
• sec_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_role_privileges2.sql Maven / Gradle / Ivy

SELECT
sec_roles.role_id,
sec_roles.role_name,
sec_privileges.privilege_desc
FROM
sec_privileges
Inner Join sec_role_privileges ON sec_role_privileges.privilege_id = sec_privileges.privilege_id
Inner Join sec_roles ON sec_role_privileges.role_id = sec_roles.role_id
where sec_roles.role_id > 0
ORDER BY
sec_roles.role_name ASC