REVOKE (Sequence)
Revokes sequence privileges from users and roles.
Syntax
REVOKE [ GRANT OPTION FOR ] { privilege[,...] | ALL [ PRIVILEGES ] } ON { SEQUENCE [[database.]schema.]sequence[,...] | ALL SEQUENCES IN SCHEMA [database.]schema[,...] } FROM grantee[,...] [ CASCADE ]
Parameters
|
Revokes the grant option for the specified privileges. Current privileges for grantees remain unaffected. If you omit this clause, Vertica revokes both the grant option and current privileges. |
privilege
|
One of the following privileges:
|
ALL [PRIVILEGES]
|
Revokes all sequence privileges that also belong to the revoker. Users cannot revoke privileges that they themselves lack. The optional keyword |
|
Database and schema. The default schema is |
SEQUENCE sequence
|
Specifies the sequence on which to revoke privileges. |
|
Revokes the specified privileges on all sequences in schema schema. |
grantee
|
Specifies whose privileges are revoked, one of the following: |
|
|
Privileges
Non-superuser, one of the following:
- Ownership
- GRANT OPTION on the object
Examples
Revoke user Joe
's privileges on sequence my_seq
.
=> REVOKE ALL PRIVILEGES ON SEQUENCE my_seq FROM Joe; REVOKE PRIVILEGE