From 60684dd834a222fefedd49b19d1f0a6189c1632e Mon Sep 17 00:00:00 2001 From: Jeff Davis Date: Tue, 13 Dec 2022 17:33:28 -0800 Subject: Add grantable MAINTAIN privilege and pg_maintain role. Allows VACUUM, ANALYZE, REINDEX, REFRESH MATERIALIZED VIEW, CLUSTER, and LOCK TABLE. Effectively reverts 4441fc704d. Instead of creating separate privileges for VACUUM, ANALYZE, and other maintenance commands, group them together under a single MAINTAIN privilege. Author: Nathan Bossart Discussion: https://postgr.es/m/20221212210136.GA449764@nathanxps13 Discussion: https://postgr.es/m/45224.1670476523@sss.pgh.pa.us --- src/backend/parser/gram.y | 7 ------- 1 file changed, 7 deletions(-) (limited to 'src/backend/parser') diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y index adc3f8ced3..63b4baaed9 100644 --- a/src/backend/parser/gram.y +++ b/src/backend/parser/gram.y @@ -7502,13 +7502,6 @@ 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); -- cgit v1.2.1