Post reply

Login Name needed

  • April 23, 2004 at 8:08 am

    #101978

    HI All,

    I've attached a data base from a software vendor, he has users defined,

    for his data base

    (who own objects)  However there is no login name assoicated wiht the users.

    Is there a way to change a user adding a login name?  In Enterpise Managert I can't see how to do it.

     

    Thanks

    Richard  

     

  • April 23, 2004 at 6:54 pm

    #504103

    It depends on how the softwar itself defines it's user structure. SOme folks use tables, some try SQL logins, some use tables to define SQL logins. You need to discuss with the vendor to find out more detail.

  • April 24, 2004 at 2:49 am

    #504122

    I'm not sure that there's an easy way in Enterprise Manager if at all. However, in T-SQL using Query Analyzer you can do this using the system stored procedure sp_change_users_login.

    Books Online - sp_change_users_login

    K. Brian Kelley
    @kbriankelley

  • April 24, 2004 at 6:56 am

    #504129

    Thanks for the tip.

    sp_change_user_login does the trick. 

     

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

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