## Atul Kumar (akumar14...@gmail.com): > Then I granted default "select" privileges to reader *user *to read data of > all tables created by writer *user* using below command: > > alter default privileges in schema <custom schema> grant select on tables > to <reader user>.
"ALTER DEFAULT PRIVILEGES allows you to set the privileges that will be applied to objects created in the future. (It does not affect privileges assigned to already-existing objects.)" That's the first two sentences from https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html If you want to grant/revoke access on existing objects, use plain old GRANT/REVOKE: https://www.postgresql.org/docs/current/sql-grant.html Regards, Christoph -- Spare Space.
