Checking Roles Granted to a User
user_role_privs stores roles granted to a user.
The columns in user_role_privs:
| Column | Type | Description |
|---|---|---|
| username | VARCHAR2(30) | Name of the user to whom the role has been granted |
| granted_role | VARCHAR2(30) | Name of the role granted to the user |
| admin_option | VARCHAR2(3) | Whether the user is able to grant the role to another user or role (YES or NO) |
| default_role | VARCHAR2(3) | Whether the role is enabled by default when the user connects to the database (YES or NO) |
| os_granted | VARCHAR2(3) | Whether the role was granted by the operating system (YES or NO) |
SELECT * FROM user_role_privs;
A user who creates a role is granted that role by default.
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: