Tuesday, December 21, 2010

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'

No comments:

Post a Comment