SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

It Depends

Add to Technorati Favorites Add to Google
Browse by Tag : Security,SSC Article (RSS)

Building a Security Philosophy Posted on SQLServerCentral.com

By Andy Warren in It Depends | 08-19-2008 1:38 AM | Categories: Filed under: , ,
Rating: (not yet rated) Rate this |  Discuss | 1,295 Reads | 312 Reads in Last 30 Days |no comments

This was actually posted about a week ago, fell behind a little during travelling. Building a Security Philosophy was written to get people to think about they approach security. Do you give the proverbial Junior DBA only partial access? Do you believe in table access? Do you use the built in roles?

I have opinions on the topic, but it's not clear that there are always right answers, and definitely some that are situational. Many of us have the philosophy that we acquired at the first job, or from the first manager or peer - at some point it's worth revisiting to decide if we still agree with those principles held for so long!