|
SYSIBM.SYSUSERAUTH www.cadcobol.com - linguagem de programação COBOL |
|
|
|
|
| Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. |
Records the system privileges held by users.
| Nome da coluna | Tipo do dado | Descrição | Uso |
| GRANTOR | CHAR(8) NOT NULL | Authorization ID of the user who granted the privileges. | G |
| GRANTEE | CHAR(8) NOT NULL | Authorization ID of the user that holds the privilege. Could also be PUBLIC for a grant to PUBLIC. |
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 |
| CHAR(1) NOT NULL | Not used | N | |
| BINDADDAUTH | CHAR(8) NOT NULL | Whether the GRANTEE can use the BIND subcommand with the ADD option: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| BSDSAUTH | CHAR(1) NOT NULL | Whether the GRANTEE can issue the RECOVER BSDS command: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| CREATEDBAAUTH | CHAR(1) NOT NULL | Whether the GRANTEE can create databases and automatically receive DBADM authority over the new databases: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| CREATEDBCAUTH | CHAR(1) NOT NULL | Whether the GRANTEE can execute the CREATE DATABASE statement to create new databases and automatically receive DBCTRL automatically receive DBCTRLauthority over the new databases: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| DISPLAYAUTH | CHAR(1) NOT NULL | Whether the GRANTEE can use the DISPLAY commands: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| RECOVERAUTH | CHAR(1) NOT NULL | Whether the GRANTEE can use the RECOVER INDOUBT command: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| STOPALLAUTH | CHAR(1) NOT NULL | Whether the GRANTEE can use the STOP command: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| STOSPACEAUTH | CHAR(1) NOT NULL | Whether the GRANTEE can use the STOSPACE utility: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| SYSADMAUTH | CHAR(1) NOT NULL | Whether the GRANTEE has system administration authority: blank Privilege is not held G Privilege was granted with the GRANT option Y Privilege was granted without the GRANT option GRANTEE has the privilege with the GRANT option for a value of either Y or G. |
G |
| SYSOPRAUTH | CHAR(1) NOT NULL | Whether the GRANTEE has system operator authority: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| TRACEAUTH | CHAR(1) NOT NULL | Whether the GRANTEE can issue the START TRACE and STOP TRACE commands: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without 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 |
| MON1AUTH | CHAR(1) NOT NULL WITH DEFAULT |
Whether the GRANTEE can obtain IFC serviceability data. blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| MON2AUTH | CHAR(1) NOT NULL WITH DEFAULT |
Whether the GRANTEE can obtain IFC data. blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| CREATEALIASAUTH | CHAR(1) NOT NULL WITH DEFAULT |
Whether the GRANTEE can execute the CREATE ALIAS statement. blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| SYSCTRLAUTH | CHAR(1) NOT NULL WITH DEFAULT |
Whether the GRANTEE has SYSCTRL authority: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option GRANTEE has the privilege with the GRANT option for a value of either Y or G. |
G |
| BINDAGENTAUTH | CHAR(1) NOT NULL WITH DEFAULT |
Whether the GRANTEE has BINDAGENT privilege: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| ARCHIVEAUTH | CHAR(1) NOT NULL WITH DEFAULT |
Whether the GRANTEE is privileged to use the ARCHIVE LOG command: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
| CHAR(1) NOT NULL WITH DEFAULT |
Not used | N | |
| CHAR(1) NOT NULL WITH DEFAULT |
Not used | N | |
| GRANTEDTS | TIMESTAMP NOT NULL WITH DEFAULT |
Time when the GRANT statement was executed. The value is '1985-04-01.00.00.00.000000' for the one installation row. |
G |
| CREATETMTABAUTH | CHAR(1) NOT NULL WITH DEFAULT |
Whether the GRANTEE has CREATETMTABAUTH privilege: blank Privilege is not held G Privilege is held with the GRANT option Y Privilege is held without the GRANT option |
G |
|
|
|
