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.	G
GRANTEE	CHAR(8) NOT NULL	Authorization ID of the user who holds the privilege. Could also be PUBLIC for a grant to PUBLIC.	G
QUALIFIER	CHAR(8) NOT NULL	The qualifier of the table space (the database name), if the row describes a privilege over a table space. Blank otherwise.	G
NAME	CHAR(18) NOT NULL	Name of the buffer pool, collection, DB2 storage group, or table space. Could also be ALL when USE OF ALL BUFFERPOOLS is granted.	G
	CHAR(1) NOT NULL	Not used	N
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 C DBCTL D DBADM L SYSCTRL M DBMAINT S SYSADM P PACKADM (on a specific collection) A PACKADM (on collection *)	G
OBTYPE	CHAR(1) NOT NULL	Object type: B Buffer pool C Collection S Storage group R Table space	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
USEAUTH	CHAR(1) NOT NULL	Whether the privilege is held with the GRANT option: G Privilege is held with the GRANT option Y Privilege is held without the GRANT option The authority held is PACKADM when the OBTYPE is C (a collection) and QUALIFIER is PACKADM. The authority held is CREATE IN when the OBTYPE is C and QUALIFIER is blank.	G
IBMREQD	CHAR(1) NOT NULL	Whether the row came from the basic machine-readable material (MRM) tape: N No Y Yes	G
GRANTEDTS	TIMESTAMP NOT NULL WITH DEFAULT	Time when the GRANT statement was executed.	G