• Online, Self-Paced
Course Description

Protecting the security of an Oracle Database 12c system involves controlling and monitoring database access. In this course, you'll learn how to manage privileges and use roles, profiles, quotas, and password security in Oracle Database 12c. You'll learn how to detect and resolve lock conflicts, and you'll learn how to enable and manage auditing of database activity. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).

Learning Objectives

User, System, and Object Privileges

  • start the course
  • describe database user accounts in Oracle Database 12c
  • describe administrative user accounts in Oracle Database 12c
  • describe how users are authenticated with the Oracle Database 12c
  • describe administrator authentication when connecting to the Oracle Database 12c
  • create a user and unlock or reset a user's password in Oracle Database 12c
  • administer system privileges in Oracle Database 12c
  • administer object privileges in Oracle Database 12c
  • analyze privileges in Oracle Database 12c

Roles, Profiles, Quotas, and Passwords

  • describe the predefined database roles for managing privileges in Oracle Database 12c
  • create and assign profiles to users and modify the default profile in Oracle Database 12c
  • assign quotas on tablespaces in Oracle Database 12c
  • describe how to apply the principle of least privilege in Oracle Database 12c
  • implement password security in Oracle Database 12c

Managing Data Concurrency

  • describe the locking mechanisms for managing data concurrency in Oracle Database 12c
  • identify causes of lock conflicts and detect lock conflicts in Oracle Database 12c
  • resolve lock conflicts and deadlocks in Oracle Database 12c

Database Security and Auditing

  • provide an overview of database security, auditing, and compliance monitoring in Oracle Database 12c
  • describe the requirements to implement unified auditing in Oracle Database 12c
  • enable unified auditing in Oracle Database 12c
  • describe the predefined unified audit policies in Oracle Database 12c
  • create unified audit policies in Oracle Database 12c
  • enable, disable, alter, and view audit policies in Oracle Database 12c
  • describe value-based auditing in Oracle Database 12c

FGA and the Auditing Trail

  • describe fine-grained auditing (FGA) and assign FGA policies in Oracle Database 12c
  • describe considerations and guidelines for fine-grained auditing (FGA) in Oracle Database 12c
  • archive and purge the audit trail in Oracle Database 12c

Practice: Manage Privileges and Auditing

  • create a user, assign a role, and configure auditing in Oracle Database 12c

Framework Connections