Aug 11, 2013

How to check the privileges assigned to a role



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