Who should attend
- Database administrators
- Network administrators
- System analysts
Prerequisites
Required Prerequisites:
- Good knowledge of Oracle Database
Suggested Prerequisites:
- Perform RMAN backup and recovery
- Use Oracle Data Pump export and import
- Create and manage users, roles, and privileges
- Administer listeners
Course Objectives
- Analyze any security risks of their organization
- Find appropriate Oracle solutions to meet the security, privacy and compliance requirements of their organization
- Find solutions to secure database access through the network
- Configure appropriate authentication for the database or enterprise users in the organization
- Control data access and integrity in their organization using the appropriate feature or option or product like privileges or Oracle Label Security
- Ensure data confidentiality using an encryption solution like Transparent Data Encryption, or Data Redaction or Oracle Data Masking
- Audit user actions using any of the auditing features like unified auditing
Course Content
- Introduction
- Understanding Security Requirements
- Choosing Security Solutions
- Implementing Basic Database Security
- Securing Data on the Network
- Using Basic and Strong User Authentication
- Configuring Global User Authentication
- Using Proxy Authentication
- Using Privileges and Roles
- Using Privilege Analysis
- Using Application Contexts
- Implementing Virtual Private Database
- Implementing Oracle Label Security
- Redacting Data
- Using Oracle Data Masking
- Using Transparent Sensitive Data Protection
- Encryption Concepts and Solutions
- Encrypting with DBMS_CRYPTO Package
- Using Transparent Data Encryption
- Database Storage Security
- Using Unified Audit
- Using Fine-Grained Audit