SQL - SYSIBM.SYSCONTEXTAUTHIDS - 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.SYSCONTEXTAUTHIDS
Db2 for z/OS 12.0.0

A tabela SYSCONTEXTAUTHIDS contém uma linha para cada ID de autorização com o qual o contexto confiável pode ser usado.
O esquema é SYSIBM.

The SYSCONTEXTAUTHIDS table contains one row for each authorization ID with which the trusted context can be used.
The schema is SYSIBM.

Column name Data type Description Use
CONTEXTID INTEGER
NOT NULL
The internal trusted context ID. G
AUTHID VARCHAR(128)
NOT NULL
The primary authorization ID that can reuse a connection.
When RACF® is used, this is a RACF profile name that contains the primary authorization IDs that are permitted to use the connection in the identified trusted context.
A RACF profile name in this column has an ampersand (&) sign as the first character, to distinguish it from an authorization ID.
G
AUTHENTICATE CHAR(1)
NOT NULL
Whether authentication is required for the authorization ID in the AUTHID column:
Y
Authentication token is required for the authorization ID.
For local requests, the token is the password.
For remote requests, the token can be a password, a RACF passticket, or a Kerberos token
N
Authentication is not required
G
ROLE VARCHAR(128)
NOT NULL
The role for the authorization ID in the AUTHID column.
The role supersedes the default role that is defined for the trusted context.
G
CREATEDTS TIMESTAMP
NOT NULL
The time when the authorization ID is added to the trusted context. G
IBMREQD CHAR(1)
NOT NULL
A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.
For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

G
SECURITYLABEL VARCHAR(24)
NOT NULL
RACF security label for AUTHID. The security label supersedes the default security label, if any, that is defined for the context. G
SYS_START TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS ROW BEGIN
Reserved for future IBM® use. G
SYS_END TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS ROW END
Reserved for future IBM use. G
TRANS_START TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS TRANSACTION
START ID
Reserved for future IBM use. G


© Copyright IBM Corp.