Course Details

Previous Page


User Security and Auditing in Oracle Database 12c


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/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).

Target Audience
Data warehouse administrator; database administrators; database designers; support engineer; technical administrator

Prerequisites
None

Expected Duration (hours)
2.3

Lesson Objectives

User Security and Auditing in Oracle Database 12c

  • 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
  • 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
  • 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
  • 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
  • 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
  • create a user, assign a role, and configure auditing in Oracle Database 12c
  • Course Number:
    od_dbre_a03_it_enus