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:

Table 1. 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: ALTER The privilege to alter the XML schema. USAGE The privilege to use the XML schema.
IS_GRANTABLE	GRANTABLE	VARCHAR(3)	Indicates whether the privilege is grantable to other users. NO The privilege is not grantable. YES The privilege is grantable.
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