• Toreador (2/7/2011)


    sp_helptext[sp_change_users_login] will reveal all 🙂

    Presumably the permissions on ALTER USER will perform the required security checks on whether the user has permission to perform the action. The sp_change_users_login does seem to do quite a lot, but apart from listing the orphaned users in a database it should be possible to do everything with CREATE LOGIN and ALTER USER.