diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-01-21 02:16:21 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-01-21 02:16:21 +0000 |
| commit | 4789e9880148660c7126aef4fbaf5563be6ff167 (patch) | |
| tree | 8fb5643fbab6a7c41b36cc19409749df1ddb03ad /src/backend/parser/gram.y | |
| parent | 33feb55c478af5f7a4c61232729c524d69d8d965 (diff) | |
| download | postgresql-4789e9880148660c7126aef4fbaf5563be6ff167.tar.gz | |
Add GRANT ON SEQUENCE syntax to support sequence-only permissions.
Continue to support GRANT ON [TABLE] for sequences for backward
compatibility; issue warning for invalid sequence permissions.
[Backward compatibility warning message.]
Add USAGE permission for sequences that allows only currval() and
nextval(), not setval().
Mention object name in grant/revoke warnings because of possible
multi-object operations.
Diffstat (limited to 'src/backend/parser/gram.y')
| -rw-r--r-- | src/backend/parser/gram.y | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y index ceb7143ce2..41b22d811c 100644 --- a/src/backend/parser/gram.y +++ b/src/backend/parser/gram.y @@ -11,7 +11,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.521 2005/12/29 04:53:18 neilc Exp $ + * $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.522 2006/01/21 02:16:19 momjian Exp $ * * HISTORY * AUTHOR DATE MAJOR EVENT @@ -3322,6 +3322,13 @@ privilege_target: n->objs = $2; $$ = n; } + | SEQUENCE qualified_name_list + { + PrivTarget *n = makeNode(PrivTarget); + n->objtype = ACL_OBJECT_SEQUENCE; + n->objs = $2; + $$ = n; + } | FUNCTION function_with_argtypes_list { PrivTarget *n = makeNode(PrivTarget); |