September 25, 2010 at 12:31 am
Hi,
I have given a user db_datareader under owned Schema and i want to change this to db_datawriter,but when i try to change the db_datareader check box is disable mode unable to change in SSMS.
If any have ideal,plz let me know...
Thanks
Koteswar Rao
September 28, 2010 at 12:32 pm
You set the user as the owner of the db_datareader schema?
Go into the database, Security->Schemas. Right click db_datareader and change the Schema owner back to db_datareader from the user name. Then you should be able to alter the user's roles in the database.
EDIT: Piece of advice. Never make a user the owner of a database role or its schema. It causes too many problems.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply