Sample Header Ad - 728x90

which privileges should I grant to run the query below in a postgresql instance

0 votes
2 answers
415 views
I faced a task: find out minimal user permissions that I should grant to run a query: select grantee, routine_name from information_schema.routine_privileges where routine_name in ('pg_read_file', 'pg_read_binary_file') group by grantee, routine_name; I tried to grant GRANT SELECT ON information_schema.routine_privileges TO ; and I failed to get any result If I run the query under the postgres user - I get all grantees corresponding routine_name But what should I do to get those records under the test_user account ? P.S. A remark: as I understood the information_schema.routine_privileges is a view: so I granted a SELECT on tables: pg_proc, pg_namespace and pg_authid to my test_user but still was unsuccesfull P.P.S. It seems to me I have to troubleshoot: find out an object the user has insufficient access rights.. But how to find theese objects?
Asked by Gregor76 (5 rep)
May 3, 2023, 07:17 PM
Last activity: Jul 12, 2025, 07:05 AM