Postgres SQL on AWS RDS how to grant permission for schema, select on tables to user
1
vote
1
answer
2222
views
I have logged in as superuser and created a readonly user.
When I run grant command, it says that schema does not exists
I am logging in as root:
sql -h myhost_name -U root -d postgres -W
grant usage on schema autorsid to readonly ;
ERROR: schema "autorsid" does not exist
while schema does exists but schema owner is not root.
Isn't when you are superuser, we should be able to grant permissions for all database/schema/tables etc.
Asked by Sanjay
(71 rep)
May 29, 2018, 06:19 PM
Last activity: Aug 6, 2025, 10:02 AM
Last activity: Aug 6, 2025, 10:02 AM