Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    17

    Unanswered: remove orphaned users

    hello,
    After identifying orphaned users for a database how do i got about removing them.
    My concern is that these users exist in other databases and i do not want those users to be affected.

    thanks

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    users are specific to a database so removing them from one will not affect other databases (unless you do cross database queries and they are linked to the same login)

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    I'd used SP_CHANGE_USERS_LOGIN with AUTO_FIX which fixes them and revoked permissions on the database.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •