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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 sql server Security Standards?

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/functions

Of course, Beta through Live should be limited to the databases that a user has access to...

Your Thoughts?
   

- Advertisement -