Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit55a7490

Browse files
committed
Fix test_checkdb_with_least_privileges. Add GRANT EXECUTE on function pgpro_edition for amcheck indexes
1 parent02aef65 commit55a7490

File tree

1 file changed

+5
-5
lines changed

1 file changed

+5
-5
lines changed

‎tests/checkdb.py

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -726,6 +726,9 @@ def test_checkdb_with_least_privileges(self):
726726
'GRANT EXECUTE ON FUNCTION pg_catalog.pg_control_system() TO backup; '
727727
'GRANT EXECUTE ON FUNCTION pg_catalog.string_to_array(text, text) TO backup; '
728728
'GRANT EXECUTE ON FUNCTION pg_catalog.array_position(anyarray, anyelement) TO backup;'
729+
'GRANT EXECUTE ON FUNCTION bt_index_check(regclass) TO backup; '
730+
'GRANT EXECUTE ON FUNCTION bt_index_check(regclass, bool) TO backup;'
731+
'GRANT EXECUTE ON FUNCTION pg_catalog.pgpro_edition() TO backup; '
729732
)
730733
ifProbackupTest.enterprise:
731734
# amcheck-1.1
@@ -766,6 +769,7 @@ def test_checkdb_with_least_privileges(self):
766769
'GRANT EXECUTE ON FUNCTION pg_catalog.array_position(anyarray, anyelement) TO backup; '
767770
'GRANT EXECUTE ON FUNCTION bt_index_check(regclass) TO backup; '
768771
'GRANT EXECUTE ON FUNCTION bt_index_check(regclass, bool) TO backup;'
772+
'GRANT EXECUTE ON FUNCTION pg_catalog.pgpro_edition() TO backup; '
769773
)
770774
# checkunique parameter
771775
ifProbackupTest.enterprise:
@@ -804,18 +808,14 @@ def test_checkdb_with_least_privileges(self):
804808
'GRANT EXECUTE ON FUNCTION pg_catalog.array_position(anycompatiblearray, anycompatible) TO backup; '
805809
'GRANT EXECUTE ON FUNCTION bt_index_check(regclass) TO backup; '
806810
'GRANT EXECUTE ON FUNCTION bt_index_check(regclass, bool) TO backup;'
811+
'GRANT EXECUTE ON FUNCTION pg_catalog.pgpro_edition() TO backup; '
807812
)
808813
# checkunique parameter
809814
ifProbackupTest.enterprise:
810815
node.safe_psql(
811816
"backupdb",
812817
"GRANT EXECUTE ON FUNCTION bt_index_check(regclass, bool, bool) TO backup")
813818

814-
ifProbackupTest.enterprise:
815-
node.safe_psql(
816-
"backupdb",
817-
"GRANT EXECUTE ON FUNCTION pg_catalog.pgpro_edition() TO backup")
818-
819819
# checkdb
820820
try:
821821
self.checkdb_node(

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp