Restricting Access to Rows › Assigning Row-level Security to Data Tables › Assigning Row-level Security › Step 1: Assigning a Security Name to a Table

Step 1: Assigning a Security Name to a Table

Fran Snell's APPLICANT table contains information about job applicants and their salary requirements. Fran has already assigned passkeys to Forrest that allow him to modify and add to this table. To be sure that the salary information over $50,000 is not accessible to Forrest, Fran puts row-level security on the table.

To assign a security name to a table, perform the following steps:

1. Enter APPLICANT in the Table Name field of the Activity Selection (ASEL) screen.
2. Type RSEC in the screen name field of the ASEL screen to access the Row-Level Security screen:

                                               CA
     rsec   CA - Automatic System Facility           ** Activity Selection **
     DC560004 SELECT A TABLE
   
     User Name: SNELL
   
     _ PF1 - Help                  _ PF5 - Select Data     _ PF13  - Query
     _ PF2 - Define Table          _ PF7 - Page Backward   _ PF14  - Signon
     _ PF3 - Load Data             _ PF8 - Page Forward    _ PA1   - Prior Level
     _ PF4 - Display/Change Data   _ PF9 - Passkey         _ CLEAR - Leave ASF
                                                           _ PF15  - Administrator
   
     Table Name.: applicant
     Table Owner: SNELL
                                                                    Page:  1  of  1
   
     _ APPLICANT
     _ JOB
     _ JOB AND APPLICANT
   
   

3. Press [Enter] to access the RSEC screen. Once on the RSEC screen, specify the security name of the table (SALSEC) next to the Security Name field:

                                                   CA
     RSEC   CA - Automatic System Facility           ** Row Level Security **
     DC560314 ADD/MODIFY SECURITY NAME AND GENERIC COLUMN NAMES
     Table Name: APPLICANT
                                                      _ PF1 - Help  Page:  1  of  1
   
     Security Name: salsec
   
   
              Column Name                      Generic Column Name
     NAME
     STREET
     CITY
     STATE
     ZIP CODE
     PHONE NUMBER
     POSITION APPLIED FOR
     SALARY REQUIREMENT
     EVALUATION: STRONG, WEAK, MEDIUM
   
   

4. Press [Enter] to allow ASF to record the security name in the SRT table.