Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-03-19 : 09:22:40
|
| Marino writes "hi,On a sql server 2005 database, we would like to limit the possibilities of the .net developers.So that they can create, alter, delete and execute stored proc's, views, user defined functions. But we don't want them to alter tables! How is the most dynamic method to get this done?If you guys want to know why (there may be a better way), we want to implement versioning on the db.A central person will get requests to alter tables (columns, FK, triggers ...). This person will create the script and safe this in a pre-defined location (under source control).This isn't really needed for the procedures and such because every rollout we can just generate those scripts from development without the risk of data loss or errors.I hope you guys can help me.Regards,Marino" |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-20 : 01:11:28
|
| Try the following...GRANT ALTER ON SCHEMA::dbo TO TestUser GRANT CREATE PROCEDURE TO TestUser GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA::dbo TO TestUser MohammedU |
 |
|
|
|
|
|
Security