Create ALTR Row Access Policies
Row Access Policies are created on the Row Access tab page in ALTR's Policy UI, → → . To create a Row Access Policy:
To create row access policy:
Select in the Navigation menu.
Click Row Access tab.
Click Add New button.
Select a Database , Schema and Table where the policy is applied.
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.
Click Next.
Select a User Group who has limited access to rows within the table.
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.
Note
ALTR does not sample customer data except where absolutely necessary. Because of this, customers must manually enter column values when defining row access policies.
Warning
These fields are case sensitive. Be careful to enter the data exactly as it matches the real column values
Click Next.
Enter a cosmetic name for the Row Access Policy Name.
Click the 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.