Post reply

Securables of a user at DB level

  • May 11, 2011 at 7:59 am

    #250570

    Hi,

    I got to copy a database from one server to another. So copied it and transfered all the logings also. Now here i found that securables din't get transfered for all the useres of the DB. Can any one help me out in transfering securables of users also please.

  • May 11, 2011 at 9:36 am

    #1323154

    do you mean the SIDs don't match? If so search technet/msdn for methods to move logins from one server to another. I suspect most DBAs have different ways to do this depending upon their environments - the ms docs will give you a good start.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • May 12, 2011 at 6:54 am

    #1323621

    If it is a SID issue then use ALTER user or sp_change_users_login 'auto_fix'

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

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