You can list of the list of orphan user by executing below query.
EXEC sp_change_users_login 'Report'
To remove/Delete Orphan User you can use below query.
exec sp_revokedbaccess 'DJ'
Advertisements
You can list of the list of orphan user by executing below query.
EXEC sp_change_users_login 'Report'
To remove/Delete Orphan User you can use below query.
exec sp_revokedbaccess 'DJ'
Maybe handy to tell/explain where to use? in database or what/where, Windows only or also MySQL(i)/ PostgreSQL