How to give permission to a user in a read only database ?

Question

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

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

saurabh.x.sinha Ten Centuries Points: 1125 More actions · Answer 1

Ten Centuries

Points: 1125

January 21, 2015 at 8:29 am

Please ignore

eneskutuk Valued Member Points: 54 More actions · Answer 2

Create the login on primary db first. And then, give it the permissions you want. After that, get the SID of the login by using this code:

select sid from sys.syslogins

where name = 'login_name'

And finally, create the login on read-only db with the same SID of the login.

sp_addlogin 'login_name', @passwd='mellon',

@sid = the_sid, @defdb='MASTER'