DBA GENESIS
Courses
Contact
Members
More
Looking for a script that will list all roles with privileges and any roles granted to other roles.
You will have to query ROLE_SYS_PRIVS
select privilege from role_sys_privs where role='SALES_CLERK';
Check this article for more details:
https://www.support.dbagenesis.com/post/users-roles-profiles-in-oracle
You will have to query ROLE_SYS_PRIVS
select privilege from role_sys_privs where role='SALES_CLERK';
Check this article for more details:
https://www.support.dbagenesis.com/post/users-roles-profiles-in-oracle