Post reply

Sql Logins

  • April 30, 2005 at 12:48 am

    #88856

    Hi

    I am facing one problem. I created SQL login for our employees, giving access to difftenet databases with different permiossions. The problem is when i restore the database in the server,  the permissions were reset.

    Can any one please suggest me what to do, to keep the permissions on, after i restore the Database.

    Thanks

    G.Srinivas Reddy

     

     

     

  • April 30, 2005 at 2:31 am

    #556123

    Dear Srinivas,

    Are u restoring the datbase on the same instance or different instance ?


    subban

  • April 30, 2005 at 2:54 am

    #556124

    Dear Subhan

     It is different instance.

    GSR

     

  • April 30, 2005 at 3:01 am

    #556125

    If it on a different instance/server,

    1. Create the login name

    2. Restore the DB

    3. Attach DB user with the Login name using

    SP_CHANGE_USERS_LOGIN 'UPDATE_ONE', 'DB USER NAME','SQL SERVER LOGIN NAME'

     

    SUBHAH


    subban

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

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