We want to set up Database Security for all our TEST Databases. We need users to have Read/write access to All tables,Be able to Create Stored Procedures, Create Views,Create UDF, View Diagrams.
We have Granted them access to db_datareader,db_datawriter and Granted the Create privilages seperately.
The problem is with these permissions they can't Alter the objects they just created.
By Default All Developers are members of dbo schema.
If i Grant them Alter permissions to the schema then they can alter the Table definations. This is something we don't want them to do.
We can't have Developers to have a seperate schema because lot of code has been migrated from 2000 and is embedded with dbo. and the fact is we don't understand the schema culture very well.
Any suggessions would be helpful.