Restricting Access to Rows › Assigning Row-level Security to Data Tables › Assigning Row-level Security › Correcting Errors

Correcting Errors

If any of the catalog entries (user, group, owner) that have been entered don't exist or the format of the WHERE criteria is incorrect, the system displays the message: ERROR ON VALIDATION, PROCEED TO MESSAGE SCREEN. If this happens, identify and correct the error by performing the steps described below.

1. Press [PF5] to view the error messages on the Message screen. For example, if you tried to enter a group ID that was not entered in the catalog, you would get the message:

                                               CA
     MSGS   CA - Automatic System Facility           ** Message Screen **
   
                                            _ PF2 - Print Messages  Page:  1  of  1
     DC432065 (E) GROUP C1500, NOT DEFINED IN CATALOG
   

2. Press [Clear] to return to the RLOD screen. At the RLOD screen, press [Clear] again to return to the ASEL screen. On the ASEL screen, type RSEL in the screen name field. Press [Enter] to access the RSEL screen.
3. On the RSEL screen, next to the STATUS column, enter NE 'V' to select entries with validation errors:

                                               CA
     RSEL   CA - Automatic System Facility       *Row Level Security Selection*
     DC560603 ENTER SELECTION CRITERIA
     Table Name:
                  _ PF1 - Help      _ PF2 - Message Screen          Page:  1  of  1
   
      ID           Column Name                      Selection Criteria
     0001 GROUP
     0002 USER
     0003 OWNER
     0004 SECURITY-NAME
     0005 STATUS                           ne 'v'
     0006 WHERE-CLAUSE
     0007 GROUP-SEQUENCE-NUMBER
     0008 TIME-STAMP
     0009 DATE-STAMP
     0010 WORK-GROUP
   
   
   
   
                             Additional Selection Criteria
   

4. Press [Enter] twice to display the invalid SRT entries on the RLOD screen:

                                                 CA
    PF1 = ADD;PF2 = CHANGE;PF3 = DELETE;PF4 = VALIDATE;ENTER = NEXT;CLEAR = EXIT
     $SECURITY-RUNTIME-TABLE$
   
     GROUP                            C1500
   
     USER
   
     OWNER                            SNELL
   
     SECURITY-NAME                    SALSEC
   
     STATUS                           (E) ERROR IN VALIDATION
   
     WHERE-CLAUSE                     SALARY LT 1
   

5. Enter the correct information on the RLOD screen. Press [PF2] to change the row and then [PF4] to validate.

Assigning Security to a Group

If CA-ICMS is installed, you can associate security names with entire groups of users at once by associating the group ID (instead of the user ID) with a security name.