Home Forums SQL Server 2008 SQL Server 2008 - General Grant db_datareader database role to a user for a readonly database RE: Grant db_datareader database role to a user for a readonly database

  • January 13, 2011 at 3:41 pm

    #1273333

    You create a login and user on the source system.

    You then migrate that login to the new system (the user will come through log shipping) using the same SPID.

    But we do not want to create these users in Source production instance. Is there any way to create the logins and give access to standby mode database on secondary?

    Thanks