How can we remove Orphan User Instead of fixing it?


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

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

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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s