diff options
| author | Andrew Dunstan | 2022-11-28 15:08:42 +0000 |
|---|---|---|
| committer | Andrew Dunstan | 2022-11-28 17:08:14 +0000 |
| commit | b5d6382496f2b8fc31abd92c2654a9a67aca76c6 (patch) | |
| tree | 2f9521bf4654a1643f7987b1dbc1247b81283ff3 /src/backend/parser | |
| parent | 1f059a440864021b23b0667e7c0cb664710b660d (diff) | |
Provide per-table permissions for vacuum and analyze.
Currently a table can only be vacuumed or analyzed by its owner or
a superuser. This can now be extended to any user by means of an
appropriate GRANT.
Nathan Bossart
Reviewed by: Bharath Rupireddy, Kyotaro Horiguchi, Stephen Frost, Robert
Haas, Mark Dilger, Tom Lane, Corey Huinker, David G. Johnston, Michael
Paquier.
Discussion: https://postgr.es/m/20220722203735.GB3996698@nathanxps13
Diffstat (limited to 'src/backend/parser')
| -rw-r--r-- | src/backend/parser/gram.y | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y index 9384214942..b1ae5f834c 100644 --- a/src/backend/parser/gram.y +++ b/src/backend/parser/gram.y @@ -7482,6 +7482,13 @@ privilege: SELECT opt_column_list n->cols = NIL; $$ = n; } + | analyze_keyword + { + AccessPriv *n = makeNode(AccessPriv); + n->priv_name = pstrdup("analyze"); + n->cols = NIL; + $$ = n; + } | ColId opt_column_list { AccessPriv *n = makeNode(AccessPriv); |