Post reply

Authority removed from User Mappings after restore

  • July 21, 2008 at 3:12 am

    #195522

    Following the restore of a database, the Login for a user still exists but the authority for the database I have restored has been removed from User Mappings. Is there a procedure that I can use, similar to the sp_change_users_login, that I can store and run from the master database, passing in the name of the database for which I want to add the authority?

  • July 21, 2008 at 4:32 am

    #845645

    [font="Verdana"]You can use this sp_change_users_login procedure itself to map the user with the login. [/font]

    Regards..Vidhya Sagar
    SQL-Articles

  • July 21, 2008 at 4:39 am

    #845654

    The user still exists and has the correct authority on the database itself after the restore. I need to update the Login to add the authority for the database back in User Mappings.

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

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