Re: Grant request - Mailing list pgsql-admin

From Stephen Frost
Subject Re: Grant request
Date
Msg-id 20201218162030.GD16415@tamriel.snowman.net
Whole thread Raw
In response to Grant request  (Ron Watkins <rwatki@gmail.com>)
Responses Re: Grant request  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Greetings,

* Ron Watkins (rwatki@gmail.com) wrote:
> I have a Azure production server, and a group of users is requesting select
> permissions for all tables, views, sequences, etc.
> This is for all existing and all new objects in all schemas in the database.
> I don't see any kind of "db_datareader" role. Suggestions?

https://commitfest.postgresql.org/31/2702/

Hopefully will be included in PG14.  Would be great to have folks who
have this requirement take a look at and play with that patch and make
sure that the role meets your requirements.

Thanks,

Stephen

Attachment

pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate
Next
From: Ron
Date:
Subject: Re: Grant request