SQL Reference

SYSCAT.TBSPACEAUTH

Containes one row for each user or group whi is granted USE privilege on a particular table space.

Table 90. SYSCAT.TBSPACEAUTH Catalog View

Column Name Data Type Nullable Description
GRANTOR VARCHAR(128)
Authorization ID of the user who granted USE privilege or SYSIBM.
GRANTEE VARCHAR(128)
Authorization ID of the user or group who hold the privileges.
GRANTEETYPE CHAR(1)

U = Grantee is an individual user.
G = Grantee is a group.

TBSPACE VARCHAR(18)
Name of 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.

Column Name	Data Type	Description
GRANTOR	VARCHAR(128)	Authorization ID of the user who granted USE privilege or SYSIBM.
GRANTEE	VARCHAR(128)	Authorization ID of the user or group who hold the privileges.
GRANTEETYPE	CHAR(1)	U = Grantee is an individual user. G = Grantee is a group.
TBSPACE	VARCHAR(18)	Name of 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.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]