Vertica Analytics Platform Version 9.2.x Documentation

Named Sequence Privileges

A named sequence can require up to three sets of privileges:

Create Privileges

To create a sequence, a user must have CREATE privileges on a schema that contains the sequence.

Usage Privileges

Only the sequence creator/owner and superusers can initially access a new sequence. Other users must be granted the following privileges by a superuser or the sequence owner:

  • SELECT privilege on the sequence.
  • USAGE privilege on the schema that contains the sequence.

These privileges enable users to invoke functions CURRVAL and NEXTVAL on a sequence, either directly on the sequence itself, or implicitly through a table that references the sequence.

Management Privileges

Vertica provides the following SQL statements to manage partitions. Each requires its own set of privileges:

SQL Statement Required Privileges
DROP SEQUENCE Sequence owner or schema owner
ALTER SEQUENCE…RENAME TO Sequence owner with USAGE and CREATE privileges on the schema of the sequence to rename.
ALTER SEQUENCE…SET SCHEMA

Sequence owner with USAGE privilege on the current schema, and CREATE privilege on the destination schema.

ALTER SEQUENCE…OWNER TO Current sequence owner.

For details on granting and revoking sequence privileges, see GRANT (Sequence) and REVOKE (Sequence) in the SQL Reference Manual.