Tabelas SYSIBM

Nome da coluna	Tipo de dados	Descrição	Uso
GRANTOR	CHAR(8) NOT NULL	Authorization ID of the user who granted the privilege. Could also be PUBLIC or PUBLIC followed by an asterisk.	G
GRANTEE	CHAR(8) NOT NULL	Authorization ID of the user who holds the privileges, the name of a plan that uses the privileges or PUBLIC for a grant to PUBLIC.	G
LOCATION	CHAR(16) NOT NULL	Always contains blanks	S
COLLID	CHAR(18) NOT NULL	Collection name for the package or packages on which the privilege was granted.	G
NAME	CHAR(8) NOT NULL	Name of the package on which the privileges are held. An asterisk (*) if the privileges are held on all packages in a collection.	G
	CHAR(8) NOT NULL	Not used	N
TIMESTAMP	TIMESTAMP NOT NULL	Timestamp indicating when the privilege was granted.	G
GRANTEETYPE	CHAR(1) NOT NULL	Type of grantee: blank Authorization ID P Application plan	G
AUTHHOWGOT	CHAR(1) NOT NULL	Authorization level of the user from whom the privileges were received. This authorization level is not necessarily the highest authorization level of the grantor. blank Not applicable A PACKADM (on collection *) C DBCTL D DBADM L SYSCTRL M DBMAINT P PACKADM (on a specific collection) S SYSADM	G
BINDAUTH	CHAR(1) NOT NULL	Whether GRANTEE can use the BIND and REBIND subcommands against the package: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held withou the GRANT option	G
COPYAUTH	CHAR(1) NOT NULL	Whether GRANTEE can COPY the package: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held withou the GRANT option	G
EXECUTEAUTH	CHAR(1) NOT NULL	Whether GRANTEE can execute the package: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held withou the GRANT option	G
IBMREQD	CHAR(1) NOT NULL	Whether the row came from the basic machine readable material (MRM) tape: N No Y Yes	G