Post reply

Authority removed from User Mappings after restore

  • 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 2 posts - 1 through 3 (of 3 total)

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