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

Stairway to SQL Security Expand / Collapse
Author
Message
Posted Monday, August 22, 2011 10:55 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 07, 2014 5:50 AM
Points: 1,792, Visits: 890
First I'll say that the Stairway series of articles are one of the most useful set of resources I've seen on-line for SQL. I'm one of those 'Accidental DBAs' who is trying to make good. I'm actually a little surprised there isn't already a Stairway series for SQL Security, but might suggest it as a viable topic.
Possible topics (off the top of my head as a neophyte) might include:

Logins, Users, Schema, and Roles
Building Custom Roles
Using Schemas, Views, and protecting data
Procedure scope
Certificates in SQL - creation, use, and gotchas
Backups, Restores, and Storage - (More than just backing up the database... what to store, and what not to keep together.)
Encryption - TDE, encrypting pwds/credit card numbers, etc.

And I'm sure there are books worth of other advanced topics that I don't even know to reference yet...
Post #1163486
Posted Monday, August 22, 2011 3:16 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
Good ideas. We have a stairway in mind, just need to get it moving.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1163643
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse