SQL - SYSIBM.SYSDBAUTH - www.cadcobol.com.br


Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SYSIBM.SYSDBAUTH
Records the privileges held by users over databases.

Nome da coluna Tipo do 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. (35)  G
 GRANTEE  CHAR(8) NOT NULL  Application ID of the user who holds the privilege. Could also be PUBLIC for a grant to  PUBLIC.  G
 NAME  CHAR(8) NOT NULL  Database name.  G
   CHAR(12) NOT NULL  Internal use only  I
 DATEGRANTED  CHAR(6) NOT NULL  Date the privileges were granted; in the form yymmdd.  G
 TIMEGRANTED  CHAR(8) NOT NULL  Time the privileges were granted; in the form hhmmssth.  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		  G
 CREATETABAUTH  CHAR(1) NOT NULL  Whether the GRANTEE can create tables within the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 CREATETSAUTH  CHAR(1) NOT NULL  Whether the GRANTEE can create table spaces within the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 DBADMAUTH  CHAR(1) NOT NULL  Whether the GRANTEE has DBADM authority over the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 DBCTRLAUTH  CHAR(1) NOT NULL  Whether the GRANTEE has DBCTRL authority over the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 DBMAINTAUTH  CHAR(1) NOT NULL  Whether the GRANTEE has DBMAINT authority over the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 DISPLAYDBAUTH  CHAR(1) NOT NULL  Whether the GRANTEE can issue the DISPLAY command for the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 DROPAUTH  CHAR(1) NOT NULL  Whether the GRANTEE can issue the ALTER DATABASE and DROP DATABASE statement:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 IMAGCOPYAUTH  CHAR(1) NOT NULL  Whether the GRANTEE can use the COPY, MERGECOPY, MODIFY, and QUIESCE utilities on the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 LOADAUTH  CHAR(1) NOT NULL  Whether the GRANTEE can use the LOAD utility to load tables in the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 REORGAUTH  CHAR(1) NOT NULL  Whether the GRANTEE can use the REORG utility to reorganize table spaces and indexes in the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 RECOVERDBAUTH  CHAR(1) NOT NULL  Whether the GRANTEE can use the RECOVER and REPORT utilities on table spaces in the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 REPAIRAUTH  CHAR(1) NOT NULL  Whether the GRANTEE can use the DIAGNOSE and REPAIR utilities on table spaces and indexes in the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 STARTDBAUTH  CHAR(1) NOT NULL  Whether the GRANTEE can use the START command against the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 STATSAUTH  CHAR(1) NOT NULL  Whether the GRANTEE can use the CHECK and RUNSTATS utilities against the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 STOPAUTH  CHAR(1) NOT NULL  Whether the GRANTEE can issue the STOP command against the database:

 blank     Privilege is not held
 G           Privilege held with the GRANT option
 Y            Privilege is held without the GRANT option		  G
 IBMREQD  TIMESTAMP NOT NULL
 WITH DEFAULT;		  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

© Copyright IBM Corp.