Friday, April 13, 2012 11:14 AM
I am facing issue while updating user roles in SQL server. The description of the issue as follows
Step 1. Created user with user name “support” with default rights.
Step 2. I double clicked(or selecting property) to edit roles and rights then assigned user rights on click of apply system trough’s “support” user already exists though I am not creating user I am just updating user, Please find attached screenshot for same.
Step 3. Now I deleted user “support” and created again with assigning proper rights it says user already present in group and without giving confirmation user will appear in servers users list(I think transaction not implemented here)
Please guide me
Thanks and Regards,
Ajay K N
Ajay K.N Mob:9242979790 Blog: "http://detaildotnet.blogspot.com/"
Friday, April 13, 2012 11:28 AM
What has happened here is that when you create a SQL login and then provide that login with rights to a database if you drop the login from the instance before you remove it from the databases the login is dropped from the instance but the database level permissions for the login still exists. That's why when you re-add the login you get the error that it already exists.
In SSMS > Expand Databases > Security > Users > Remove the "support" user from each database then drop the login from the instance and finally re-add it with the rights you need.
- Marked As Answer by amber zhangModerator Monday, April 23, 2012 8:49 AM