Oracle Database 11g: Introduction to Database Security and Solutions

• identify security requirements and compliance mandates
• recognize security risks
• recognize how to define and implement a security policy
• recognize how to enforce a security policy
• recognize ways to apply security practices
• recognize how to protect data
• recognize how to control access
• configure the management agent and monitoring credentials

Oracle Database 11g: Database Security

• configure database security in Oracle Database 11g
• recognize how to manage accounts in Oracle Database 11g
• manage passwords in Oracle Database 11g
• recognize ways to protect the data dictionary
• use the Configuration Management Pack
• manage passwords
• manage violations in Oracle 11g

Oracle Database 11g: Database Auditing

• recognize how to implement basic database auditing
• recognize how to implement auditing of users and objects
• recognize how FGA is implemented
• alter the DEFAULT profile
• perform auditing of privileged users
• implement fine-grained auditing

Oracle Database 11g: Basic User and Strong Authentication

• recognize how to perform basic user authentication
• recognize the features of strong authentication
• configure strong authentication
• implement OS authentication of a local user
• use passwords in authentication
• view the contents of the wallet

Oracle Database 11g: Enterprise User Security and Proxy Authentication

• recognize how to set up Enterprise User Security
• recognize how to work with Enterprise User Security
• recognize how authentication works in three tiered systems
• recognize proxy authentication solutions
• manage users authenticated by proxy authentication
• recognize how to audit users with proxy authentication
• set up Enterprise User Security
• use schemas for authentication
• implement proxy authentication

Oracle Database 11g: Privileges, Roles, and Application Contexts

• recognize how roles and privileges can be used
• recognize how to use secure application roles
• recognize how an application context is used
• recognize how to implement an application context accessed globally
• use roles in Oracle Database 11g
• use application context in Oracle Database 11g

Oracle Database 11g: Virtual Private Database

• recognize how a Virtual Private Database works recognize how a policy group is implemented
• recognize how to work with policies recognize the best practices for VPD use policies in Oracle
• Database 11g

Oracle Database 11g: Oracle Label Security and the Data Masking Pack

• recognize how Oracle Label Security works
• recognize how to create a policy
• recognize how data labels are created
• create labels and policies in Oracle Database 11g
• apply policies in Oracle Database 11g
• test access control
• recognize how data masking works
• create and use data masking
• use the Data Masking Pack

Oracle Database 11g: Encryption Concepts

• identify the issues and challenges of encryption recognize how to manage keys in Oracle Database
• 11g recognize how to generate an encryption key encrypt and decrypt in Oracle Database 11g use
• encryption in Oracle Database 11g

Oracle Database 11g: Transparent Data Encryption

• recognize how Transparent Data Encryption is set up configure encrypted columns implement
• Transparent Data Encryption identify ways to apply file encryption create and recover backups

Oracle Database 11g: Oracle Net Services and Listener Security

• recognize the uses of checklists
• restrict network IP addresses
• encrypt network traffic
• configure Net Security
• restrict listener privileges
• administer and monitor a listener
• configure listener security

Oracle Database 11g: Firewalls, Oracle Connection Manager, and SQL*Plus Security

• recognize how firewalls are used configure Oracle Connection Manager set up a firewall using
• CMAN recognize how the PUP table is used in SQL *Plus configure security using SQL *Plus