SQL Reference

SYSCAT.DBAUTH

Records the database authorities held by users.

Table 51. SYSCAT.DBAUTH Catalog View

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

DBADMAUTH CHAR(1)
Whether grantee holds DBADM authority over the database:

Y = Authority is held.
N = Authority is not held.

CREATETABAUTH CHAR(1)
Whether grantee can create tables in the database (CREATETAB):

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

BINDADDAUTH CHAR(1)
Whether grantee can create new packages in the database (BINDADD):

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

CONNECTAUTH CHAR(1)
Whether grantee can connect to the database (CONNECT):

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

NOFENCEAUTH CHAR(1)
Whether grantee holds privilege to create non-fenced functions.

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

IMPLSCHEMAAUTH CHAR(1)
Whether grantee can implicitly create schemas in the database (IMPLICIT_SCHEMA):

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

LOADAUTH CHAR(1)
Whether grantee has the privilege to use the LOAD utility:

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

Column Name	Data Type	Description
GRANTOR	VARCHAR(128)	SYSIBM or authorization ID of the user who granted the privileges.
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.
DBADMAUTH	CHAR(1)	Whether grantee holds DBADM authority over the database: Y = Authority is held. N = Authority is not held.
CREATETABAUTH	CHAR(1)	Whether grantee can create tables in the database (CREATETAB): Y = Privilege is held. N = Privilege is not held.
BINDADDAUTH	CHAR(1)	Whether grantee can create new packages in the database (BINDADD): Y = Privilege is held. N = Privilege is not held.
CONNECTAUTH	CHAR(1)	Whether grantee can connect to the database (CONNECT): Y = Privilege is held. N = Privilege is not held.
NOFENCEAUTH	CHAR(1)	Whether grantee holds privilege to create non-fenced functions. Y = Privilege is held. N = Privilege is not held.
IMPLSCHEMAAUTH	CHAR(1)	Whether grantee can implicitly create schemas in the database (IMPLICIT_SCHEMA): Y = Privilege is held. N = Privilege is not held.
LOADAUTH	CHAR(1)	Whether grantee has the privilege to use the LOAD utility: Y = Privilege is held. N = Privilege is not held.

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

[ DB2 List of Books | Search the DB2 Books ]