Give user read only access to all databases current and future ?

Question

Give user read only access to all databases current and future ?

MarvinTheAndriod

SSCarpal Tunnel

Points: 4972
More actions
November 14, 2013 at 9:26 am

#282467

Is there a way to give a user read only access to all databases current and future, without having to add them in for each individual database ?

Viewing 3 posts - 1 through 2 (of 2 total)

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

krypt0rg Old Hand Points: 327 More actions · Answer 1

for new databases, you can create a server side DDL trigger that tracks CREATE_DATABASE event and in there just execute 'create user' for your DB,. more info :

http://technet.microsoft.com/en-us/library/ms186406.aspx

barsuk SSChampion Points: 12280 More actions · Answer 2

for 'future' databases-create a user in a Model DB and every time you create a new database, that user will be there.