Understanding the Roles of Oracle 12c

Running head: UNDERSTANDING THE ROLES OF ORACLE 12C
Understanding the roles of Oracle 12c
Name of the student:
Name of the university:
Author Note

1UNDERSTANDING THE ROLES OF ORACLE 12C
Oracle 12c and relevance of its two innovative roles:
Database auditing is the recording and monitoring of chosen user actions. Over Oracle
Database 12c, it is useful to context-dependent and concise precise logging. This decreases the
performance overhead related to auditing. Moreover, it enables a more efficient audit log analysis.
Oracle 12’s first default role AUDIT_ADMIN, is helpful to configure the audit. It also administers
the policies of the unified audit and various audit policies that are fine-grained. Further, it is useful to
fetch and examine the audit data. The AUDIT_VIEWER is also beneficial for the users to see and
make an assessment of the audit data. This is also helpful to EXECUTE privileges over the PL/SQL
packages of DBMS_AUDIT_UTIL. However, to perform this the user requires the role of the
external auditor ("Auditing Database Activity", 2019).
The main function of the above roles is to distinguish the flexibility and duty to business that
intends to designate particular users in managing audit settings and fetch activities of audits. These
architectures help in unifying the present trials of an audit to one audit trail. It enables easy
management and rising the protection of audit data that is created from the database ("Unified
Auditing AUDIT_ADMIN and AUDIT_VIEWER Roles Changes", 2019). They are introduced to
enforce strong internal controls. This makes the site to meet the regulatory compliance necessities. It
helps to control various activities of business and seek tasks that deviated from the policy of the
companies.
It gets translated to strongly protected access to the application software and database. This it
assures that the patches are applicable over the schedule and prevent necessary modifications.
Through developing these audit policies, audit records can be generated for compliance and audit
personnel ("Oracle 12c Audit for Security and Compliance", 2019). However, it must be kept in