Database/Security Best Practices at

Presentation Overview

Our Philosophy + Implementation

How does it really work?

DBAs and SAs are partners

DBAs and Developers are also partners

Enable and support rapid application development

Provide tools that support our policies/procedures

Provide tools that support our policies/procedures (continued)

Best Practices

Close the “windows”

Close the “doors”

Close the “holes”

Close the “holes” (continued)

authenticate appropriately

authorize appropriately

authorize appropriately (continued)

grant  privileges appropriately

grant  CONTROL or GRANT OPTION appropriately

audit at the appropriate levels

Benefits

Summary

Questions?

Thank You.