Privileges assigned to a role
----------------------------
select * from dba_sys_privs where grantee='DBA';
/* here DBA is role name */
Privileges and roles assigned to user
------------------------------------
Select a.grantee User_name, a.granted_role role, b.privilege from DBA_ROLE_PRIVS a, DBA_SYS_PRIVS b where
a.granted_role=b.grantee and a.grantee='SCOTT'
check more about this on https://forums.oracle.com/thread/2140697
No comments:
Post a Comment