How to add read only access to all databases

Question

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 739541 More actions · Answer 1

I'm not sure if your script has a problem. I think you need this to be two separate batches, so a GO might be needed between these commands.

However, there's no way to grant read only access to future logins/users. That would have to be done for every new database.