Access Policies

You can create the following access policy types to restrict access to sensitive information to only those users authorized to view it:

You can create access policies for any table type, columnar, external, or flex. You can also create access policies on any column type, including joins.

Important: If you have a table with both a row level access policy and a column level access policy, Vertica filters the row level access policy first. Then Vertica uses the column level access policy to filter the columns.

Prerequisites

If no users or roles exist, you must create them before creating an access policy. For more information, see Creating a Database User and Creating Database Roles.

In This Section