Find Orphan users for each database in a given SQL Instance

  • Comments posted to this topic are about the item Find Orphan users for each database in a given SQL Instance

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Save a tree... Please don't waste paper unless you really need to!

    When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'

  • Thanks for the script.

    A question, in newer version of SQL server, like 2012 later, it has the contained user of databases which is isolated with logins and instance.

    The script will not include those users, correct?

    Thanks

  • Good Question! Logins which doesn't match their sid in SQL Server login and User database or A login exist in user database and not in SQL Logins this will give us orphan users and we will check in this case only. Contained database concept is which user has access to only DB not SQL Login, so i guess to avoid orphan users only this concept was introduced.

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Save a tree... Please don't waste paper unless you really need to!

    When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'

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

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