Post reply

Find Orphan users for each database in a given SQL Instance

  • July 2, 2016 at 4:18 pm

    #314797

    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'

  • July 15, 2016 at 10:35 am

    #1890367

    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

  • July 18, 2016 at 7:41 am

    #1890592

    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