SQL Reference

SYSCAT.PACKAGEAUTH

Contains a row for every privilege held on a package.

Table 69. SYSCAT.PACKAGEAUTH Catalog View

Column Name Data Type Nullable Description
GRANTOR VARCHAR(128)
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.

PKGSCHEMA VARCHAR(128)
Name of the package on which the privileges are held.
PKGNAME CHAR(8)
CONTROLAUTH CHAR(1)
Indicates whether grantee holds CONTROL privilege on the package:

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

BINDAUTH CHAR(1)
Indicates whether grantee holds BIND privilege on the package:

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

EXECUTEAUTH CHAR(1)
Indicates whether grantee holds EXECUTE privilege on the package:

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

Column Name	Data Type	Description
GRANTOR	VARCHAR(128)	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.
PKGSCHEMA	VARCHAR(128)	Name of the package on which the privileges are held.
PKGNAME	CHAR(8)
CONTROLAUTH	CHAR(1)	Indicates whether grantee holds CONTROL privilege on the package: Y = Privilege is held. N = Privilege is not held.
BINDAUTH	CHAR(1)	Indicates whether grantee holds BIND privilege on the package: Y = Privilege is held. N = Privilege is not held.
EXECUTEAUTH	CHAR(1)	Indicates whether grantee holds EXECUTE privilege on the package: 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 ]