Roles of Oracle 12c: Database Auditing and Security Report

This report provides an in-depth analysis of the roles within Oracle 12c, specifically focusing on AUDIT_ADMIN and AUDIT_VIEWER. It highlights the importance of these roles in database auditing, security, and compliance. The report explains how AUDIT_ADMIN configures audit policies and manages audit data, while AUDIT_VIEWER allows users to assess audit information. The roles are crucial for establishing internal controls, meeting regulatory requirements, and monitoring business activities. The report also emphasizes the significance of auditing in deterring improper activities, analyzing suspicious actions, and notifying auditors of unauthorized activities. Furthermore, the report details how these roles contribute to data security, access control, and the generation of audit records for compliance purposes. The analysis draws upon several sources to provide a comprehensive understanding of Oracle 12c's auditing capabilities. This information is useful for anyone studying database administration and security.

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

2UNDERSTANDING THE ROLES OF ORACLE 12C
mind that selective measures are to be taken with auditing. This assures that this requires the needs
of business compliance.
The above roles are used to accomplish various functions. It enables accountability for
actions. It involves activities considered in a specific row, table, schema that has been affecting
particular content. This deters users from improper activities on the basis of accountability.
Furthermore, they are useful to analyze suspicious activities. Apart from this, they are able to notify
the auditors of the activities of the unauthorized authors. Thus they are able to collect and control the
data about particular activities of activities.
Here, for instance, data administrator can collect the statistics where tables are upgraded,
detect the number of concurrent users connecting during peak times and amount of logical I/Os put
into place. Moreover, it is helpful to find out issues with access control deployments and
authorization. Here, one can generate the audit policies that are intended to never give rise to audit
records ("Unified Auditing, one of the new features in Oracle Database 12c - ORACLE-HELP",
2019), since the data is secured in various processes. Besides, it is reminded that policies can create
audit records. This is helpful to understand the security measures that are never suitably deployed.

3UNDERSTANDING THE ROLES OF ORACLE 12C
References:
Auditing Database Activity, (2019). Retrieved from
https://docs.oracle.com/database/121/TDPSG/GUID-BF747771-01D1-4BFB-8489-
08988E1181F6.htm#TDPSG50000
Oracle 12c Audit for Security and Compliance, (2019). Retrieved from
https://www.netwrix.com/oracle_12c_audit.html
Unified Auditing AUDIT_ADMIN and AUDIT_VIEWER Roles Changes, (2019). Retrieved from
http://www.dba86.com/docs/oracle/12.2/UPGRD/unified-auditing-audit_admin-
audit_viewer-changes.htm
Unified Auditing, one of the new features in Oracle Database 12c - ORACLE-HELP, (2019).
Retrieved from http://oracle-help.com/oracle-12c/unified-auditing-one-new-features-oracle-
database-12c/