EXA_ROLE_RESTRICTED​_OBJ_PRIVS

This system table lists all connection objects that certain restricted scripts were granted access to through one of the roles of the current user. 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