Oracle Database Administration/Database Security

This lesson introduces Oracle database security.

Objectives and Skills
Objectives and skills for the database security portion of Oracle Database Administration I certification include:
 * Implementing Oracle Database Security
 * Database Security and Principle of Least Privilege
 * Work with Standard Database Auditing

Readings

 * 1) Oracle: Database 2 Day + Security Guide

Multimedia

 * 1) YouTube: Security in the Database

Privileges

 * 1) Review Oracle: Managing Compliance.
 * 2) Use the following query to identify UTL packages that PUBLIC has EXECUTE privileges for:
 * 3) Consider revoking EXECUTE access from PUBLIC for all UTL packages, but at a minimum restrict the following:

Auditing

 * 1) Review Oracle: Audit Trail.
 * 2) Enable auditing.
 * 3) Use the following queries to enable auditing:
 * 4) Stop and restart the database so that the changes take effect using the following queries:
 * 5) Audit database connections using the following queries:
 * 6) Examine the audit log.
 * 7) View the audit log using the following query: