Overview
-
Learn how to secure, protect, and harden an Oracle 12c database by configuring users, permissions and privileges, roles, auditing, and encryption.
Syllabus
-
Introduction
- Welcome
- What you need to know
- Exercise files
- Why database security is important
- Authentication an database users
- Authorization and permissions
- Database auditing
- Database encryption
- Roles of DBAs in Oracle security
- Download the course VM
- Enable archive mode
- Users, schemas, and the SYSDBA
- Create new database users
- Grant and evoke system privileges
- Grant database-wide system privileges
- Tablespace quotas
- Object permissions
- Password management policies
- The WITH GRANT and WITH ADMIN options
- Enforce password complexity
- Viewing users, permissions, and polices
- Deleting a database user
- Local vs. common user concepts
- Creating local users
- Creating common users
- Separating object owners and access
- Introduction to database roles
- Creating, assigning, and dropping roles
- Viewing existing roles and role grants
- Roles with ADMIN OPTION
- Configure audit parameters
- Creating unified audit policies
- Testing audit polices
- View the audit trail
- Using standard auditing
- Fine-grained auditing
- Manage the audit trail
- Configure the keystore
- Create encryption key
- Encryping data in tables
- Encrypting tablespaces
- Encrypting Data Pump backups
- Encrypting RMAN Backups
- Restore encrypted RMAN Backup
- Open the wallet after DB restart
- What's next?
