How can we remove Orphan User Instead of fixing it?

1 Reply

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'

1 thought on “How can we remove Orphan User Instead of fixing it?”

Neuke Pietje December 12, 2013 at 11:06 pm

Maybe handy to tell/explain where to use? in database or what/where, Windows only or also MySQL(i)/ PostgreSQL

Reply ↓

Thanks for the comment, will get back to you soon... Jugal Shah Cancel reply