Checking System Privileges Granted to a Role
role_sys_privs stores system privileges have been granted to a role.
The columns in role_sys_privs:
| Column | Type | Description |
|---|---|---|
| role | VARCHAR2(30) | Name of the role |
| privilege | VARCHAR2(40) | System privilege granted to the role |
| admin_option | VARCHAR2(3) | Whether the privilege was granted with the ADMIN option (YES or NO) |
SELECT * FROM role_sys_privs ORDER BY privilege;
Home »
Oracle »
User, Privilege, Role »
Oracle »
User, Privilege, Role »
Roles:
- Creating Roles
- Granting Roles to a User
- Checking Roles Granted to a User
- Checking System Privileges Granted to a Role
- Checking Object Privileges Granted to a Role
- Default Roles
- Revoking a Role
- Dropping a Role
Related: