January 17, 2013 at 11:39 am
I created a user and gave them dbreader and dbwriter... but they cannot open Design View. They can if I grant them DBO permission. How can I allow them to open Design View without DBO?
January 17, 2013 at 1:15 pm
What do you mean by design view? Is this BIDS/Visual Studio, Report Builder, another application?
Joie Andrew
"Since 1982"
January 17, 2013 at 2:04 pm
When you go to a table in SSMS and right click on the table and left click on DESIGN
January 18, 2013 at 6:54 am
If they are only in the db_datareader and db_datawriter Roles why would they need to Design a table? Neither of those Roles give them permissions to do that.
Membership in the db_owner Role (not the same thing as dbo by the way) would allow them to alter any table in the database.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 18, 2013 at 7:06 am
Thank you for the information OPC. I am sorry... I meant db_owner.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply