• happycat59 (2/17/2013)


    Database mappings are actually relationships between the syslogins table in the master database and sysusers table in the user database.

    Note that the correct catalogs now are

    sys.server_principals for server level logins

    sys.database_principals for database users

    sys.database_permissions for database user permissions

    sys.database_role_members for database user role membership

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉