SQL Reference

SYSCAT.TABAUTH

Contains one or more rows for each user or group who is granted a privilege on a particular table or view in the database. All the table privileges for a single table or view granted by a specific grantor to a specific grantee appear in a single row.

Table 85. SYSCAT.TABAUTH Catalog View

Column Name Data Type Nullable Description
GRANTOR VARCHAR(128)
Authorization ID of the user who granted the privileges or SYSIBM.
GRANTEE VARCHAR(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.

TABSCHEMA VARCHAR(128)
Qualified name of the table or view.
TABNAME VARCHAR(128)
CONTROLAUTH CHAR(1)
Indicates whether grantee holds CONTROL privilege on the table or view:

Y = Privilege is held.
N = Privilege is not held.

ALTERAUTH CHAR(1)
Indicates whether grantee holds ALTER privilege on the table:

Y = Privilege is held.
N = Privilege is not held.
G = Privilege is held and grantable.

DELETEAUTH CHAR(1)
Indicates whether grantee holds DELETE privilege on the table or view:

Y = Privilege is held.
N = Privilege is not held.
G = Privilege is held and grantable.

INDEXAUTH CHAR(1)
Indicates whether grantee holds INDEX privilege on the table:

Y = Privilege is held.
N = Privilege is not held.
G = Privilege is held and grantable.

INSERTAUTH CHAR(1)
Indicates whether grantee holds INSERT privilege on the table or view:

Y = Privilege is held.
N = Privilege is not held.
G = Privilege is held and grantable.

SELECTAUTH CHAR(1)
Indicates whether grantee holds SELECT privilege on the table or view:

Y = Privilege is held.
N = Privilege is not held.
G = Privilege is held and grantable.

REFAUTH CHAR(1)
Indicates whether grantee holds REFERENCE privilege on the table or view:

Y = Privilege is held.
N = Privilege is not held.
G = Privilege is held and grantable.

UPDATEAUTH CHAR(1)
Indicates whether grantee holds UPDATE privilege on the table or view:

Y = Privilege is held.
N = Privilege is not held.
G = Privilege is held and grantable.

Column Name	Data Type	Description
GRANTOR	VARCHAR(128)	Authorization ID of the user who granted the privileges or SYSIBM.
GRANTEE	VARCHAR(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.
TABSCHEMA	VARCHAR(128)	Qualified name of the table or view.
TABNAME	VARCHAR(128)
CONTROLAUTH	CHAR(1)	Indicates whether grantee holds CONTROL privilege on the table or view: Y = Privilege is held. N = Privilege is not held.
ALTERAUTH	CHAR(1)	Indicates whether grantee holds ALTER privilege on the table: Y = Privilege is held. N = Privilege is not held. G = Privilege is held and grantable.
DELETEAUTH	CHAR(1)	Indicates whether grantee holds DELETE privilege on the table or view: Y = Privilege is held. N = Privilege is not held. G = Privilege is held and grantable.
INDEXAUTH	CHAR(1)	Indicates whether grantee holds INDEX privilege on the table: Y = Privilege is held. N = Privilege is not held. G = Privilege is held and grantable.
INSERTAUTH	CHAR(1)	Indicates whether grantee holds INSERT privilege on the table or view: Y = Privilege is held. N = Privilege is not held. G = Privilege is held and grantable.
SELECTAUTH	CHAR(1)	Indicates whether grantee holds SELECT privilege on the table or view: Y = Privilege is held. N = Privilege is not held. G = Privilege is held and grantable.
REFAUTH	CHAR(1)	Indicates whether grantee holds REFERENCE privilege on the table or view: Y = Privilege is held. N = Privilege is not held. G = Privilege is held and grantable.
UPDATEAUTH	CHAR(1)	Indicates whether grantee holds UPDATE privilege on the table or view: Y = Privilege is held. N = Privilege is not held. G = Privilege is held and grantable.

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

[ DB2 List of Books | Search the DB2 Books ]