EXA_ROLE_RESTRICTED_OBJ_PRIVS
This system table lists all connection objects to which certain, restricted scripts were granted access to, either granted directly to the current user or indirectly via other roles. Only users with the system privilege SELECT ANY DICTIONARY have access to the table.
Column Name | Description |
---|---|
OBJECT_SCHEMA | Schema of the object for which the restricted privilege has been granted |
OBJECT_NAME | Name of the object for which the restricted privilege has been granted |
OBJECT_TYPE | Type of the object for which the restricted privilege has been granted |
FOR_OBJECT_SCHEMA | Schema of the object that the privilege is restricted to |
FOR_OBJECT_NAME | Name of the object that the privilege is restricted to |
FOR_OBJECT_TYPE | Type of the object that the privilege is restricted to |
PRIVILEGE | The restricted privilege that is granted |
GRANTEE | Name of the user/role who has been granted the restricted privilege |
GRANTOR | Name of the user/role who has granted the restricted privilege |
OWNER | Name of the owner of the object for which the restricted privilege is granted |