Post reply

SQL 2000 - logins aliased to database - how to remove them?

  • January 28, 2008 at 9:48 am

    #120224

    Does anyone out there know how to remove the asscoiation between Logins and Databases SQL2000. We have two database on a server both sharing Logins (hundreds of) and were wondering if there is a quick way to remove the association with one of the databases - trying to avoid manually changing each one.

  • January 28, 2008 at 10:36 am

    #772550

    How about deleting the users from the database? You can do that in Enterprise Manager by expanding "Users", highlighting the users you want to disassociate from logins, and delete. It won't affect the logins or users in the other database.

    If the users own objects, you'll have to change the owners of the objects before deleting users.

    Greg

  • January 28, 2008 at 10:38 am

    #772553

    Thanks Greg. Much appreciated

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

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