User Privilege Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. User Privilege
  4. 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;