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:26 pm

    #1273325

    You can create a user without a login in SQL Server 2005 and newer. However, uyou can se these steps to simplify it for you:

    1. Create login on production server

    2. Create user in database mapped to login

    3. Drop login on production server

    4. Grant any required permissions to user in database

    5. Create login on log shipping standby server

    - a. If a SQL authenticated login, create login while specifying SID from production machine

    - b. If Windows auth. login, create login without specifying SID

    6. Make sure log shipping jobs have completed one full run since completion of step 4

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]