Named Sequence Privileges
A named sequence can require up to three sets of privileges:
To create a sequence, a user must have CREATE privileges on a schema that contains the sequence.
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.
Vertica provides the following SQL statements to manage partitions. Each requires its own set of privileges:
|SQL Statement||Required Privileges|
||Sequence owner or schema owner|
||Sequence owner with USAGE and CREATE privileges on the schema of the sequence to rename.|
Sequence owner with USAGE privilege on the current schema, and CREATE privilege on the destination schema.
|ALTER SEQUENCE…OWNER TO||Current sequence owner.|