Home Forums SQL Server 2012 SQL 2012 - General Give user read only access to all databases current and future ? RE: Give user read only access to all databases current and future ?

  • November 14, 2013 at 10:05 am

    #1666454

    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