aiDeeva.com

How can we remove Orphan User Instead of fixing it?

Written by

Jugal Shah

in

, , ,

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'

Comments

One response to “How can we remove Orphan User Instead of fixing it?”

  1. Neuke Pietje Avatar
    Neuke Pietje

    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

More posts