Skip to main content

Create ALTR Row Access Policies

Row Access Policies are created on the Row Access tab page in ALTR's Policy UI, Data Policy → Locks → Row Access. To create a Row Access Policy:

To create row access policy:

  1. Select Data PolicyLocks in the Navigation menu.

  2. Click Row Access tab.

  3. Click Add New button.

  4. Select a Database , Schema and Table where the policy is applied.

  5. Select a Reference Column that will dictate access.

    Note

    If your data doesn't display in the dropdowns, ensure your service user account has privileges to access the data.

  6. Click Next.

  7. Select a User Group who has limited access to rows within the table.

    1. For those user groups, identify the particular values of the reference column those users will be able to access. If that value is not present for a given row, those users will not be able to access the row.

  8. Click Next.

  9. Enter a cosmetic name for the Row Access Policy Name.

  10. Click the Submit button.

Once submitted, the policy enters a pending state. It may take several minutes for a row access policy to apply. If you have trouble successfully applying row access policies, contact ALTR Support.

In this section: