hope the following is the query which your looking for:
Code:SELECT * FROM dba_role_privs WHERE grantee IN (SELECT granted_role FROM dba_roles WHERE grantee = 'SCOTT') union SELECT * FROM dba_role_privs WHERE grantee = 'SCOTT'
|
Results 1 to 5 of 5
Thread: systems privsThreaded View
|
Click Here to Expand Forum to Full Width |