Certification     Oracle     Oracle Database 12c Administrator Certified Professional     1Z0-062 - Oracle Database 12c: Installation and Administration

---

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 learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).

---

---

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