Facing problem in Updateing user rights in SQL Server

Question

Dear Sir/Madam,

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:[phone] Blog: "http://detaildotnet.blogspot.com/"

Answer 1

Hi,

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.

---

Sean Massey | Consultant, iUNITE

Feel free to contact me through My Blog, Twitter or Hire Me.
Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!