can't change user permissions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

can’t change user permissions

Hello,
I am trying to change some of the permissions that I have as a user. I right click on the user and click properties. From there I change somre of the permissions and click ok. When I click ok, I get an error that says "User already exists". Does anyone know what might be causing this? Thanks in advance, Ben
This message is because the user allready exist in database user.
You have to delete user form user database and recreate a user in managment with permission you want.
Luis Martin
Moderator
SQL-Server-Performance.com
If the database is restored recently and this will have issues in the permission allocation, try to run SP_CHANGE_USERS_LOGIN to save orphaned users. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>