Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

Checking System Privileges Granted to a Role

You can check which system privileges have been granted to a role by querying role_sys_privs. SQL> desc role_sys_privs;  Name               Null?    Type  ROLE               NOT NULL VARCHAR2(30) --Name of the role.  PRIVILEGE          NOT NULL VARCHAR2(40) --System privilege granted to the role.  ADMIN_OPTION       VARCHAR2(3)           --Whether the privilege was granted with the ADMIN option. Equal to YES or NO. SELECT * FROM role_sys_privs;