SQL Reference

SYSCAT.TBSPACEAUTH

Contains one row for each user or group who is granted USE privilege on a particular table space in the database.

Table 94. SYSCAT.TBSPACEAUTH Catalog View

Column Name	Data Type	Nullable	Description
GRANTOR	CHAR(128)		Authorization ID of the user who granted the privileges or SYSIBM.
GRANTEE	CHAR(128)		Authorization ID of the user or group who holds the privileges.
GRANTEETYPE	CHAR(1)		U = Grantee is an individual user. G = Grantee is a group.
TBSPACE	VARCHAR(18)		Name of the table space.
USEAUTH	CHAR(1)		Indicates whether grantee holds USE privilege on the table space: G = Privilege is held and grantable. N = Privilege is not held. Y = Privilege is held.