diff options
Diffstat (limited to 'src/test/modules/test_oat_hooks/sql/test_oat_hooks.sql')
| -rw-r--r-- | src/test/modules/test_oat_hooks/sql/test_oat_hooks.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/test/modules/test_oat_hooks/sql/test_oat_hooks.sql b/src/test/modules/test_oat_hooks/sql/test_oat_hooks.sql index 8b6d5373aa5..d692f52d922 100644 --- a/src/test/modules/test_oat_hooks/sql/test_oat_hooks.sql +++ b/src/test/modules/test_oat_hooks/sql/test_oat_hooks.sql @@ -25,8 +25,9 @@ GRANT SET, ALTER SYSTEM ON PARAMETER another.bogus TO regress_role_joe WITH GRAN DROP ROLE regress_role_joe; -- Check the behavior of the hooks relative to do-nothing grants and revokes -GRANT SET ON PARAMETER work_mem TO PUBLIC; -REVOKE ALTER SYSTEM ON PARAMETER work_mem FROM PUBLIC; +GRANT SET ON PARAMETER maintenance_work_mem TO PUBLIC; +REVOKE SET ON PARAMETER maintenance_work_mem FROM PUBLIC; +REVOKE ALTER SYSTEM ON PARAMETER maintenance_work_mem FROM PUBLIC; -- Check the behavior of the hooks relative to unrecognized parameters GRANT ALL ON PARAMETER "none.such" TO PUBLIC; @@ -98,3 +99,4 @@ REVOKE ALL PRIVILEGES ON PARAMETER test_oat_hooks.user_var2, test_oat_hooks.super_var2 FROM regress_role_joe; DROP ROLE regress_role_joe; +DROP ROLE regress_test_user; |