Administrative Functions of ASF › Restricting ASF Users › Limiting Row-level Security Authorization › Generating System Administration Tables

Generating System Administration Tables

Finding the Tables

You can access the system administrator tables through the System Table Maintenance (SYST) screen. To access the SYST screen:

1. Sign on with the user ID cull dba and the password assigned to CULL DBA. Your system is installed with the password DBAPASS, but this is often changed for security reasons.
2. Enter syst in the screen name field and press [Enter]. The SYST screen is shown below:

                                                    CA
  SYST   CA - Automatic System Facility           *System Table Maintenance*
  DC560727 SELECT A SYSTEM TABLE

  Table Name:

         _ PF1 - Help                       _ PF4 - Display/Change Data
         _ PF2 - Define Table               _ PF5 - Select Data
         _ PF3 - Load Data                  _ PF6 - Query


                     _ $UNSTRUCTURED-IDB-OBJECT$

                     _ $SECURITY-RUNTIME-TABLE$

                     _ $OBJECT-SECURITY-NAME-TABLE$

                     _ $SRT-OST-CROSS-REFERENCE$

From the SYST screen you can access table definition screens for the system tables.

Security Runtime Table

To generate the $SECURITY-RUNTIME-TABLE$ (SRT):

• Choose the SRT from the SYST screen and press [PF2] to access the Table Definition (TDEF) screen:

                                                      CA
    TDEF   CA - Automatic System Facility            ** Table Definition **
    DC560029 INQUIRY ONLY, SYSTEM TABLES CAN ONLY BE GENERATED THROUGH THIS SCREEN
  
           _ PF1 - Help                     _ PF4 - Extended Table Definition
           _ PF2 - Define Columns           _ PF5 - Delete Table Definition
           _ PF3 - Generate                 _ PF6 - Message Screen
  
    Table Name.: $SECURITY-RUNTIME-TABLE$
    Table Owner: IDBSYSTEM                             Defn Number:     20
    View/Stored: STORED                                Status.....: UNGENERATED
    Comments...:
  
                               Table Derivation
    Source Table #1
     Table Name.:
     Table Owner:
  
    Source Table #2
     Table Name.:
     Table Owner:
  
    Column #1:
    Column #2                                    Where Column #1 EQ Column #2
  

• Press [PF3] to generate the table.
• Press [Clear] to return to the SYST screen.

Object Security Table

To generate the $OBJECT-SECURITY-NAME-TABLE$ (OST):

• Choose the OST from the SYST screen and press [PF2] to access the Table Definition (TDEF) screen:

                                                      CA
    TDEF   CA - Automatic System Facility            ** Table Definition **
    DC560029 INQUIRY ONLY, SYSTEM TABLES CAN ONLY BE GENERATED THROUGH THIS SCREEN
  
           _ PF1 - Help                     _ PF4 - Extended Table Definition
           _ PF2 - Define Columns           _ PF5 - Delete Table Definition
           _ PF3 - Generate                 _ PF6 - Message Screen
  
    Table Name.: $OBJECT-SECURITY-NAME-TABLE$
    Table Owner: IDBSYSTEM                             Defn Number:     21
    View/Stored: STORED                                Status.....: UNGENERATED
    Comments...:
  
                               Table Derivation
    Source Table #1
     Table Name.:
     Table Owner:
  
    Source Table #2
     Table Name.:
     Table Owner:
  
    Column #1:
    Column #2                                    Where Column #1 EQ Column #2
  

• Press [PF3] to generate the table.
• Press [Clear] to return to the SYST screen.

Cross References

To generate the $SRT-OST-CROSS-REFERENCE$ (SXRF):

• Choose the SXRF from the SYST screen and press [PF2] to access the Table Definition (TDEF) screen:

                                                      CA
    TDEF   CA - Automatic System Facility            ** Table Definition **
    DC560029 INQUIRY ONLY, SYSTEM TABLES CAN ONLY BE GENERATED THROUGH THIS SCREEN
  
           _ PF1 - Help                     _ PF4 - Extended Table Definition
           _ PF2 - Define Columns           _ PF5 - Delete Table Definition
           _ PF3 - Generate                 _ PF6 - Message Screen
  
    Table Name.: $SRT-OST-CROSS-REFERENCE$
    Table Owner: IDBSYSTEM                             Defn Number:     22
    View/Stored: VIEW                                  Status.....: UNGENERATED
    Comments...:
  
                               Table Derivation
    Source Table #1
     Table Name.: $OBJECT-SECURITY-NAME-TABLE$
     Table Owner: IDBSYSTEM
  
    Source Table #2
     Table Name.: $SECURITY-RUNTIME-TABLE$
     Table Owner: IDBSYSTEM
  
    Column #1: OWNER-FROM-OST
    Column #2  OWNER                             Where Column #1 EQ Column #2
  

• Press [PF3] to generate the table.
• Press [Clear] to return to the SYST screen.