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 |
