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 |
Specifies a schema, by default myschema.thisDbObject If you specify a database, it must be the current database. |
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