summaryrefslogtreecommitdiffstats
path: root/src/test/regress/sql/init_privs.sql
blob: 4a31af27986ae081cba88d315262b9eeabfb375a (plain)
1
2
3
4
5
6
7
8
9
10
-- Test initial privileges

-- There should always be some initial privileges, set up by initdb
SELECT count(*) > 0 FROM pg_init_privs;

-- Intentionally include some non-initial privs for pg_dump to dump out
GRANT SELECT ON pg_proc TO CURRENT_USER;
GRANT SELECT (prosrc) ON pg_proc TO CURRENT_USER;

GRANT SELECT (rolname, rolsuper) ON pg_authid TO CURRENT_USER;