Oracle Database Security: Preventive Controls

Oracle Database Security: Preventive Controls Ed 1

In the Oracle Database Security: Preventive Controls course, you learn how you can use Oracle Database Security products and technologies to meet the security, privacy, and compliance requirements of your organization. The current regulatory environment of the Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act, and others, requires better security at the database level. You learn how to secure the access to your databases and how to use the Oracle Database Security products and technologies that enhance data access and confidentiality. The course provides suggested Oracle solutions for common problems.

Duration: 5 Days

Prerequisites

• Can create and manage users, roles, and privileges
• Use Oracle Data Pump to export and import and perform RMAN back up
• Can create and manage tables and tablespaces
• Use Flashback Data Archive and create PL/SQL procedures
• Familiarity with SQL*Plus and SQL*Developer
• Familiarity with Oracle Enterprise Manager Cloud Control

Audience

• Database Administrators
• Network Administrators
• Security Administrators
• Support Engineers
• System Analysts

Learning Objectives

• Secure the database access by database or enterprise users with basic or strong authentication such as SSL, Kerberos and Radius
• Protect against database bypass by using Transparent Database Encryption
• Use Oracle Wallets and Oracle Key Vault to manage encryption keys
• Reduce sensitive data exposure in applications by using Data Redaction
• Discover sensitive columns such as Credit Card Numbers by using Application Data Modeling
• Minimize sensitive data proliferation to test/dev environments by using Data Masking
• Minimize storage costs in test/dev environments by using Data Subsetting
• Understand security risks and identify appropriate Oracle solutions
• Configure general authentication and authorization
• Understand and implement Global Users
• Set up and maintain a simple wallet
• Install and use Oracle Database Vault
• Configure and use Transparent Sensitive Data Protection

Topics

• Using Basic and Strong User Authentication
• Configuring Global User Authentication
• Using Proxy Authentication
• Encryption Concepts and Solutions
• Using Built-In Encryption in Applications
• Using Transparent Data Encryption (TDE)
• Database Storage Security
• Installing Oracle Key Vault
• Using Oracle Key Vault
• Administering Oracle Key Vault
• Automated Sensitive Data Discovery
• Masking Sensitive Data in Non-Production Environments
• Subsetting Data
• Managing Data Masking and Subsetting
• Oracle Advanced Security - Data Redaction
• Oracle Transparent Sensitive Data Protection (TSDP)
• Oracle Database Vault Overview
• Configuring Database Vault
• Analyzing Privileges