Option AO. Authorization options

Use the System Catalog (ADB21) panel - Authorization options to manage authorizations for objects in the Db2 catalog.

Select option AO on the System Catalog (ADB21) panel to display the System Catalog (ADB21) panel - Authorization options, as shown in the following figure.

Figure 1. System Catalog (ADB21) panel - Authorization options
Start of change
 ADB21 min ---------- DD1A System Catalog - Authorizations --------------- 12:16
Option ===>                                                                    
                                                            DB2 System: DD1A    
 OO - Display Object options                                DB2 SQL ID: ADM001  
                                                             
Authorization options:                                                         
 GA - Storage group auths             PA - Plan authorizations                 
 DA - Database authorizations         LA - Collection authorizations           
 SA - Table space authorizations      KA - Package authorizations              
 TA - Table authorizations            HA - Schema authorizations               
 VA - View authorizations             EA - User defined data type authorization
 CA - Column authorizations           FA - Function authorizations             
 ZA - System authorizations           OA - Stored procedure authorizations     
 UA - User authorizations             QA - Sequence authorizations             
 RA - Resource authorizations         TR - Trusted contexts                    
 RO - Roles                           PM - Permissions                         
 CM - Column masks                   GVA - Global variable authorizations      
                                                                               
                                                                               
Enter standard selection criteria: Settings: '=' operator; Criteria not saved. 
Name  . . . .                            > Grantor . . .           >           
Schema  . . .                            > Grantee . . .           >           
Owner . . . .                            >                                     
In DB/Coll  .                            > Switch Catalog Copy   . . N (N/S/C) 
And/or other selection criteria (option xC shows you columns for option x)     
Column  . . .                            > Oper . .        Value . .
End of change

For optimum performance, specify selection criteria for all authorization options (xA) and enter a value for Grantor or Grantee.

Db2 Admin Tool reports authorizations based solely on the Db2 catalog. However, the actual authorization is affected by other sources that are external to the Db2 catalog, such as the following sources:
  • Installation authorities that are specified in DSNZPARM.
  • Any external security system, such as the RACF® program.
  • Any security product from another software provider.
  • Security user exits, including the ones that are supplied by IBM®.

To return to the object view, on the System Catalog (ADB21) panel, select option OO.