Note that Deloitte is transitioning the Oracle Education sales and delivery back to Oracle directly in New Zealand. Please contact Oracle directly - - +64 21 505-255

11gR2: Implement Database Vault

Course Fees: $2556.00 excl. GST
Printed Manual: $0.00 excl. GST
Course Duration: 2 days
Course Manual

Sorry, no course dates found

Database Vault is a new option that helps a DBA meet the security goals of an organisation. There are more and more requirements being put on systems regarding separation of duties and privacy and protection of data, including insider threats. A DBA needs to understand these requirements, and also the tools available for meeting them. This course introduces the student to Database Vault, including installation, configuration, and how it affects activities in the database. New security concepts are introduced, illustrated, and clearly demonstrated by relevant practices

  • How to use the various features of Oracle Database Vault
  • How to monitor and maintain an Oracle Database Vault environment
  • Install & configure Oracle Database Vault to meet your security compliance goals

Database Administrators

Security Administrators

Security Compliance Professionals

Support Engineer

Technical Consultant

SQL, PL/SQL, Database Admin Workshop 1, Oracle Security
  • Install Database Vault
  • Configure Realms to protect schemas or application data
  • Define multiple factors that represent characteristics of a user or session
  • Integrate factor values with Oracle Label Security
  • Audit Database Vault component accesses
  • Define custom rules for allowing access to data
  • Use the Database Vault browser interface
  • Monitor and report on security configuration issues and access violations


Overview of Database Vault

  • Overview of Database Vault elements and functionality
  • Component relationships
  • Database Vault example
  • Database Vault effects
  • Database Vault Administrator (DVA)
  • Reporting and monitoring
  • Database Vault API
  • Managing Database Vault databases using Enterprise Manager

Configuring Database Vault

  • Enabling Oracle Database Vault
  • Configuring an Oracle database for Database Vault
  • Database parameters altered during configuration
  • Logging into DVA
  • Database roles
  • Database Vault accounts
  • Database Vault schemas

Configuring Realms

  • Realms: Concepts
  • Creating and editing realms
  • Deleting realms
  • The realm algorithm
  • Examples of realms
  • Delivered realms
  • Realm views
  • Monitoring and reporting of realms

Defining Rule Sets

  • Rule sets: Concepts
  • Creating and editing rule sets
  • Deleting rule sets
  • Reusing rules
  • Auditing rule sets
  • Custom event handlers
  • Using rule sets with realms
  • Rule set examples

Configuring Command Rules

  • Command Rules: Concepts
  • Creating and editing command Rules
  • Delivered command rules
  • Command rule report
  • Command rule API

Extending Rule Sets

  • Factors: Concepts
  • Factor scenarios
  • Creating and editing factors
  • Managing factors:
  • Identities: Concepts
  • Purpose of identities
  • Creating an identity
  • Managing identities

Configuring Secure Application Roles

  • Secure application roles: Concepts
  • Creating and editing secure application roles
  • Deleting secure application roles
  • Secure application roles: Examples
  • Managing secure application roles:

Viewing Database Vault Reports

  • Monitoring Database Vault
  • Configuration reports
  • Auditing reports
  • Security reports
  • Object privilege reports
  • Accounts and roles reports
  • Privilege summary reports
  • System privileges reports

Implementing Best Practices

  • Identifying your security requirements
  • Suggested naming conventions
  • Separation of duty best practices
  • Identifying your security requirements
  • Audit all violations
  • Connection pooling considerations
  • Enforcing connections from an application server
  • Performance considerations