CODEWITHSUNDEEP
postgresql
Shaul Behr
Shaul Behr

Reputation: 38003

Why is Postgres not recognizing my GRANT statement?

Logged in as an admin user:

grant select on all tables in schema masterreport to readonly_user;

returns:

OK

OK, great. Now logging in to the same database as readonly_user:

select * from masterreport.sometable;

response:

ERROR: permission denied for schema masterreport

WTH is wrong here?

Upvotes: 0

Views: 109

Answers (1)

Abdel P.
Abdel P.

Reputation: 738

You need to grant usage over the schema

grant usage on schema masterreport to readonly_user

Upvotes: 3

Related Questions