May 26, 2010 at 12:38 pm
I hope this is not a silly question but here goes. Basically we have a staging database which developers are using for ETL process. This staging database will now hold live data even in the Dev environment due to the nature of the work. I need to prevent DBO access to this database because I don’t want them adding any additional users. However they can do pretty much whatever else. Can someone advise of what roles I need to assign to provide a near DBO level access without them actually owning the database and having the privilege to add other people.
So far I have provided db_datareader, db_datawriter and db_ddladmin howevere they still get error message when altering the table from the GUI. But then again when the run the TSQL for alter table its ok.
May 26, 2010 at 2:47 pm
I believe they would be receiving the error from the GUI because of a table option. If you go to Tools, Options, Designers, Table and Database Designers, Uncheck "Prevent saving changes that require table re-creation" they should be able to alter the table from the GUI without getting the error.
May 28, 2010 at 1:12 am
You can give specific alter permission to that table
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply