User Security and Auditing in Oracle Database 12c Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Expertise Level 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
Expertise Level
Intermediate