Database Security in 2005

• Vikas-94496

  Valued Member

  Points: 64

  More actions

  July 20, 2006 at 12:51 am

  #114803

  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..

• July 24, 2006 at 8:00 am

  This was removed by the editor as SPAM