Post reply

grant read access to logshipped database

  • August 18, 2010 at 2:09 pm

    #222752

    i am looking a way to grant to the databases which are in "read-only" mode. I know i can add the login on target and that will be logshipped, but there are like 100 dbs and i would need to add to individual login. I am looking if anyone has a way to create user on a "read-only" db or a way to grant access to read-only dbs.

  • August 18, 2010 at 4:50 pm

    #1208817

    ReadOnly Databases cannot be modified. Adding access to the database means modifying the database, which is not possible.

    there are 2 ways(that i can think of), grant the user access in the primary database and create the login with same SID in the secondary server. or grant the user "sa" access, which can be an issue for some sensitive databases.

  • August 19, 2010 at 9:10 pm

    #1209444

    thanks..yeah i knew both the ways..

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

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