SQL Server and MySQL Notes
Pages
(Move to ...)
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
‹
›
Home
View web version
No comments:
Post a Comment