Sample Header Ad - 728x90

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