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@xxxxxxxxx> 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
