ALL_CODE_ROLE_PRIVS describes all the roles that are associated with program units owned or accessible by the current user.
Related Views
DBA_CODE_ROLE_PRIVS describes all the roles that are associated with program units in the database.
USER_CODE_ROLE_PRIVS describes all the roles that are associated with program units owned by current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Username of the owner of the object |
|
|
|
|
Name of the object |
|
|
|
Type of the object |
|
|
|
|
|
The role associated with the object |
See Also:
Oracle Database Security Guide for more information about granting and revoking roles to and from program units