GRANT (Sequence)
Grants sequence privileges to users and roles.
Syntax
GRANT { privilege[,...] | ALL [ PRIVILEGES ] [ EXTEND ] } ON { SEQUENCE [[database.]schema.]sequence[,...] | ALL SEQUENCES IN SCHEMA [database.]schema[,...] } TO grantee[,...] [ WITH GRANT OPTION ]
Parameters
privilege |
The following privileges are valid for sequences:
|
ALL [PRIVILEGES][EXTEND]
|
Grants all sequence privileges that also belong to the grantor. Grantors cannot grant privileges that they themselves lack You can qualify
|
[database.]schema
|
Database and schema. The default schema is |
SEQUENCE sequence
|
Specifies the sequence on which to grant privileges. |
ALL SEQUENCES IN SCHEMA schema
|
Grants the specified privileges on all sequences in schema schema. |
grantee |
Specifies who is granted privileges, one of the following: |
WITH GRANT OPTION
|
Gives grantee the privilege to grant the same privileges to other users or roles, and also revoke them. For details, see Granting Privileges. |
Privileges
Non-superusers require USAGE on the schema and one of the following:
- Owner
- Privileges grantee given the option (
WITH GRANT OPTION
) of granting privileges to other users or roles.
Examples
This example shows how to grant user Joe
all privileges on sequence my_seq
.
=> CREATE SEQUENCE my_seq START 100; CREATE SEQUENCE
=> GRANT ALL PRIVILEGES ON SEQUENCE my_seq TO Joe; GRANT PRIVILEGE