Skip to content

Column-Level Access How-to

This page demonstrates how to create, modify, delete, and verify column policies which implement this data access feature.

Column-level access control enables administrators to define which columns to block and associate that with roles. Accounts linked to roles with column policies will be subject to the data access control. See Column-level Access Control for a description of the feature.

Before you begin⚓︎

Required permissions⚓︎

The account used to configure column policies requires several permissions.

Column policy management permissions:

  • add_columnpolicy
  • change_columnpolicy
  • view_columnpolicy
  • delete_columnpolicy
  • add_role_columnpolicy
  • remove_role_columnpolicy

Role management permissions for role creation:

  • add_role

Hydrolix UI permissions:

  • view_role
  • view_table

Column policy requirements⚓︎

Each column policy must be uniquely named in a table, and must include one or more existing column names in the blocked list.