Introduction
Welcome
()
What you need to know
()
Exercise files
()
1. Database Security Fundementals
Why database security is important
()
Authentication an database users
()
Authorization and permissions
()
2. Advanced Database Security Concepts
Database auditing
()
Database encryption
()
Roles of DBAs in Oracle security
()
3. Download and Set Up the Course VM
Download the course VM
()
Enable archive mode
()
4. Users and Permissions
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
()
5. Database Roles
Introduction to database roles
()
Creating, assigning, and dropping roles
()
Viewing existing roles and role grants
()
Roles with ADMIN OPTION
()
6. Auditing Access to Data
Configure audit parameters
()
Creating unified audit policies
()
Testing audit polices
()
View the audit trail
()
Using standard auditing
()
Fine-grained auditing
()
Manage the audit trail
()
7. Data Encryption
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
()
Conclusion
What's next?
()
Ex_Files_Oracle_12c_Database_Security.zip
(184 KB)