Permission Read Only User

On 3/15/19 4:37 PM, Sathish Kumar wrote:

Hi All,

I have created a read only user to perform select statements on our
database but whenever we create new tables on the database this user is
unable to view it unless I grant select again for this table. Is there a
way I can make select as default permission for this user so that in
future if I create any new tables, it will be still accessible.

Maybe this?:

https://www.postgresql.org/docs/11/sql-alterdefaultprivileges.html

--
Adrian Klaver
adrian.klaver@aklaver.com

On 3/15/19 6:44 PM, Adrian Klaver wrote:

On 3/15/19 4:37 PM, Sathish Kumar wrote:

Hi All,

I have created a read only user to perform select statements on our
database but whenever we create new tables on the database this user is
unable to view it unless I grant select again for this table. Is there a
way I can make select as default permission for this user so that in
future if I create any new tables, it will be still accessible.

Maybe this?:

https://www.postgresql.org/docs/11/sql-alterdefaultprivileges.html

That's just what we used.

Create a role READONLY who is granted CONNECT and alter the default
permissions on all your schemas to grant SELECT to that role.

Then create "user" roles which inherit from READONLY.

--
Angular momentum makes the world go 'round.