CREATE ACCESS POLICY
Creates a secure access policy that filters access to table data to users and roles. You can create access policies for table rows and columns. Vertica applies the access policy filters with each query, and returns only the data that is permissible for the current user or role.
Syntax
CREATE ACCESS POLICY ON [[database.]schema.]table { FOR COLUMN column | FOR ROWS WHERE } expression { ENABLE | DISABLE }
Parameters
[database.]schema
|
Specifies a schema, by default myschema.thisDbObject If you specify a database, it must be the current database. |
table |
The table with the target column or rows. |
FOR COLUMN column |
The column on which to apply this access policy. Must not be a column with an external data type (see Complex Types). |
FOR ROWS WHERE | The rows on which to apply this access policy. |
expression |
An SQL expression that specifies conditions for accessing row or column data:
|
ENABLE | DISABLE
|
Specifies whether to enable the access policy. If you specify DISABLE , Vertica does not use this policy. To enable a diasbled policy, call ALTER ACCESS POLICY . |
Privileges
Superuser