1.15 Process Row Level Security Maintenance

This topic provides the systematic instructions to enable or disable Row Level Security (RLS) policy.

  1. On Home screen, type UTDRLSMT in the text box, and click Next.
    The Row Level Security Maintenance screen is displayed.

    Figure 1-21 Row Level Security Maintenance


    Description of Figure 1-21 follows
    Description of "Figure 1-21 Row Level Security Maintenance"

  2. On Row Level Security Maintenance screen, click New to enter the details.
    For more information on fields, refer to the field description table.

    Table 1-19 Row Level Security Maintenance - Field Description

    Field Description
    Table Name

    Alphanumeric; 30 Characters; Optional

    Specify the table name. Alternatively, you can select table name from the option list. The list displays all valid table name maintained in the system.
    Enabled

    Optional

    Select if row level security to be enabled or not from the drop-down list. The list displays the following values:
    • Yes
    • No
    Default Status To

    Optional

    Select the defaulted status from the drop-down list. The list displays the following values:
    • Yes
    • No
    Execute Query button
    Click Execute Query to display the following details:
    • Policy Name
    • Table Name
    • Policy Function
    Enabled

    Optional

    Select if RLS policies to be enabled or not from the drop-down list. The list displays the following values:
    • Yes
    • No

    By default all the policy will be disabled.

    Note: You can create new maintenance but will be restricted to delete or amend existing/ created policies.

    On enabling the policy rule, the system will create new RLS policy. On disabling the system will drop the RLS policy.

    Note: In case of enabling or disabling RLS policy, you should either enable it or disable it all. In case of partial enabling, the system behaviour could differ.

Parent topic: Ensure Security for Fund Manager