Not to be sarcastic, but create the role and use it as group with only select privileges everywhere.
—
Jay
Sent from my iPad
> On Dec 17, 2020, at 2:25 PM, 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?
>
> --
> Ron Watkins, AI7AK
> 602.743.5272