June 25, 2008 at 9:33 am
Hi All,
I have a pre-pre deployment server with restricted use to developers. My aim is to let them release their stuff to this server. I have given them db_ddlAdmin, db_executer, db_datareader and db_datawriter permission to the DB they are assigned to. Now here are the two issues I am facing.
1. Developers are able to alter table using Script but they cannot use SSMS GUI. (I find that very strange)
2. The Developers are not able to get the Plan. That is they cannot use SHOW PLAN. What rights should I give to get the developers to be able to use SHOW PLAN. (I prefer not to make them DB Owners)
All Help towards acheiving this is very much appreciated.
Thanks
Roy
-Roy
June 25, 2008 at 10:57 am
On the show plan thing, there's an article in BOL on granting permission for showing plans:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9c18657e-2992-4ee7-ab07-7af3141ec658.htm
On not being able to use the GUI in SSMS to design tables, I've not seen that before. Not sure why it wouldn't work.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 25, 2008 at 12:23 pm
Roy Ernest (6/25/2008)
Hi All,I have a pre-pre deployment server with restricted use to developers. My aim is to let them release their stuff to this server. I have given them db_ddlAdmin, db_executer, db_datareader and db_datawriter permission to the DB they are assigned to. Now here are the two issues I am facing.
1. Developers are able to alter table using Script but they cannot use SSMS GUI. (I find that very strange)
2. The Developers are not able to get the Plan. That is they cannot use SHOW PLAN. What rights should I give to get the developers to be able to use SHOW PLAN. (I prefer not to make them DB Owners)
All Help towards acheiving this is very much appreciated.
Thanks
Roy
SQL 2005 Limits metadata visibility. you can revert to the 2000 behaviour byt issuing The corresponding GRANT VIEW ANY DEFINITION TO public;
for further troubleshooting Metadata Visibility tips check out:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d1a82fbe-c178-42bb-9212-fbdc520a8f8d.htm
* Noel
June 25, 2008 at 12:41 pm
Try to GRANT VIEW SERVER STATE and VIEW DATABASE STATE Permissions
Maninder
www.dbanation.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply