SYSXSROBJECTAUTH
The SYSXSROBJECTAUTH view contains one row for every privilege granted on an XML schema. Note that this catalog view cannot be used to determine whether a user is authorized to a XML schema because the privilege to use a XML schema could be acquired through a group user profile or special authority (such as *ALLOBJ).
The following table describes the columns in the SYSXSROBJECTAUTH view:
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
GRANTOR | GRANTOR | VARCHAR(128) Nullable
|
Reserved. Contains the null value. |
GRANTEE | GRANTEE | VARCHAR(128) | The user profile to which the privilege is granted. |
XSROBJECTSCHEMA | XSRSCHEMA | VARCHAR(128) | Name of the schema |
XSROBJECTNAME | XSRNAME | VARCHAR(128) | Name of the XML schema |
PRIVILEGE_TYPE | PRIVTYPE | VARCHAR(10) | The privilege granted:
|
IS_GRANTABLE | GRANTABLE | VARCHAR(3) | Indicates whether the privilege is grantable to other users.
|
AUTHORIZATION_LIST | AUTL | VARCHAR(10) Nullable
|
If the privilege is granted through
an authorization, contains the name of the authorization list. Contains the null value if the privilege is not granted through an authorization list. |
SYSTEM_XSR_SCHEMA | SYSXSCHEMA | CHAR(10) | System name of the schema |
SYSTEM_XSR_NAME | SYSXNAME | CHAR(10) | System name of the XML schema |