Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Security in 2005 Expand / Collapse
Author
Message
Posted Thursday, July 20, 2006 12:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 27, 2008 12:40 AM
Points: 4, Visits: 7
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.



Thanks
Vikas..
Post #295790
Posted Monday, July 24, 2006 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #296697
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse