SQL Server and MySQL Notes
Pages
Home
Contact Me
All Articles
Author Profile
Download Links
How to be DBA?
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment