Option TR. Trusted Contexts

To display this panel:

1. On the System Catalog (ADB21) panel, specify option AO, and press Enter.
2. On the System Catalog - Authorizations (ADB21) panel, specify option TR, and press Enter.

The following figure shows an example of this panel:

ADB2AN in ---------------- DB2X Trusted Contexts ----------- Row 1 to 10 of 10 
Command ===>                                                  Scroll ===> PAGE 
                                                                               
Commands: GEN                                                                
Line commands:                                                               
 RO - Roles  ID - Authids  ATTR - Attributes  DR - Definer role              
 I - Interpretation  DROP - Drop  COM - Comment  CRE - Create  AL - Alter    
 ? - Show all line commands    

                                                                                
                                     D System   Default  O E A A R I            
 Sel  Name                  Definer  T Authid   Role     T N L U C R Context ID 
      *                     *        * *        *        * * * * * * *          
 ---- --------------------- -------- - -------- -------- - - - - - - -----------
      PJCTXROW              SMITHAJ    SMITHAJ  PJROLEOW L Y N N R N          71
      PJTCN                 PJROLEOW L PJRN                N N N R N          72
      PJTCX                 PJROLEOW L MARLINX  PJRX       Y N N R N          43                                                                                                                           
******************************* END OF DB2 DATA *******************************

Columns

This panel displays the following columns:

Sel

Input field where you can enter one of the line commands listed on the panel. Enter a question mark (?) on a row to view all valid line commands.

Name

Name of the trusted context.

Definer

Authorization ID or role that defined the trusted context.

DT

Type of definer. This column can have one of the following values:

L

Role

blank

Authorization ID

System Authid

Db2 primary authoirzation ID used to establish a connection.

Default Role

Name of the trusted context default role.

OT

Indication of whether the ROLE AS OBJECT OWNER AND QUALIFIER clause is specified in the definition. This column can have one of the following values:

L

Yes

blank

No

EN

Status of the trusted context. This column can have one of the following values:

Y

Enabled

N

Disabled

AL

Indication of whether the connection is allowed to be reused for PUBLIC. This column can have one of the following values:

Y

Yes

N

No

AU

Indication of whether authentication is required for PUBLIC when ALLOWPUBLIC is Y. This column can have one of the following values:

Y

Yes

N

No

RC

Db2 release that is used to create the object. For possible values, see the list of release indicators in Db2 catalog tables (Db2 13 for z/OS).

IR

Required by IBM®. A value of Y means that the row came from the basic machine-readable material (MRM) tape. For all other possible values, see the list of release indicators in Db2 catalog tables (Db2 13 for z/OS).

Context ID

Internal context ID.

Created Timestamp

Timestamp when the trusted context was created.

Altered Timestamp

Timestamp when the trusted context was last altered.

Default Security Label

Name of the context default RACF security label.

Remarks

A character string that is provided using the COMMENT statement.

Primary commands

The following primary commands are valid on this panel:

GEN

Generates SQL from the Db2 catalog.