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. All users have access to the table.
Column Name | Description |
---|---|
OBJECT_SCHEMA
|
Schema of the object for which the restricted privilege has been granted, currently always NULL |
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 that has been granted the restricted privilege |
GRANTOR
|
Name of the user who has granted the restricted privilege, currently always NULL |
OWNER
|
Name of the owner of the object for which the restricted privilege is granted, currently always NULL |