Row-Level Security Screens › Load Row-level Security Screen—RLOD

Load Row-level Security Screen—RLOD

Description

Allows you to load rows in the $SECURITY-RUNTIME-TABLE$ to specify who has access to the rows of your tables that have row-level security applied to them.

Access

You can access the Load Row-Level Security screen by typing RLOD in the screen name field of any screen.

Sample Screen

                                                CA
 PF1 = ADD;PF2 = CHANGE;PF3 = DELETE;PF4 = VALIDATE;ENTER = NEXT;CLEAR = EXIT
  $SECURITY-RUNTIME-TABLE$

  GROUP

  USER

  OWNER

  SECURITY-NAME

  STATUS

  WHERE-CLAUSE

Fields

GROUP

Enter the name of the group you want to have access to your rows. You can do this only if CA-ICMS is installed.

USER

Enter the name of the user you want to have access to your rows. Keep in mind that the GROUP field and the USER field are mutually exclusive. You cannot make an entry in both fields at once.

OWNER

Enter the name of the owner of the table to which you are applying row-level security.

SECURITY-NAME

Enter the security name assigned to the table on the Row-Level Security screen.

STATUS

Displays the status of the row-level security assignment. This field will be one of the following:

• (I)—Validation Required
• (V)—Validated
• (E)—Error in Validation

WHERE-CLAUSE

Enter the selection criteria that defines which rows of the table the user is allowed to access.