Tabelas SYSIBM

Nome da coluna	Tipo de dado	Descrição	Uso
GRANTOR	CHAR(8) NOT NULL	Authorization ID of the user who granted the privileges. Could also be PUBLIC or PUBLIC followed by an asterisk	G
GRANTEE	CHAR(8) NOT NULL	Authorization ID of the user who holds the privilege or the name of an application plan or package that uses the privilege. PUBLIC for a grant to PUBLIC. PUBLIC followed by an asterisk for a grant to PUBLIC AT ALL LOCATIONS.	G
GRANTEETYPE	CHAR(1) NOT NULL	Type of grantee: blank GRANTEE is an authorization ID P GRANTEE is an application plan or a package. It is a package if COLLID is not blank.	G
CREATOR	CHAR(8) NOT NULL	The authorization ID of the owner of the table or view on which the update privilege is held.	G
TNAME	VARCHAR(18) NOT NULL	The name of the table or view.	G
	CHAR(12) NOT NULL	Internal use only	I
DATEGRANTED	CHAR(6) NOT NULL	Date the privilege was granted, in the form yymmdd.	G
TIMEGRANTED	CHAR(8) NOT NULL	Time the privilege was granted, in the form hhmmssth.	G
COLNAME	VARCHAR(18) NOT NULL	Name of the column to which the UPDATE privilege applies.	G
IBMREQD	CHAR(1) NOT NULL	Whether the row came from the basic machine readable material (MRM) tape: N No Y Yes	G
	CHAR(16) NOT NULL WITH DEFAULT	Not used	N
COLLID	CHAR(18) NOT NULL WITH DEFAULT	If GRANTEE is a package, its collection name. Otherwise, blank.	G
CONTOKEN	CHAR(8) NOT NULL WITH DEFAULT	If GRANTEE is a package, the consistency token of the DBRM from which the package was derived. Otherwise, blank.	S
PRIVILEGE	CHAR(1) NOT NULL WITH DEFAULT	Indicates which privilege this row describes: R Row pertains to the REFERENCES privilege. blank Row pertains to the UPDATE privilege.	G
GRANTEDTS	TIMESTAMP NOT NULL WITH DEFAULT	Time when the GRANT statement was executed.	G