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 |
|
colinbashbash
Starting Member
1 Post |
 Posted - 2009-09-03 : 17:30:53
|
| I'm actually just a developer, but I'd like to get some idea about what the standard security should be for developers.My thoughts:Developer access on a Dev Server:-data owner (create databases, tables, etc.)Developer access on a Beta Server:-Data Reader-View Definitions of tables/views/procs/procedures/functions-Allow show-plan Developer access on a UAT Server:-View Definitions of tables/views/procs/procedures/functions-Allow show-plan Developer access on a Live Server:-View Definitions of tables/views/procs/procedures/functionsOf course, Beta through Live should be limited to the databases that a user has access to...Your Thoughts? |
|
|
|
|
|
sql server Security Standards?