Oracle Database 12c Security Roles: AUDIT_ADMIN & VIEWER

This report provides an executive summary of database security, emphasizing the critical role of data protection within organizations. It analyzes Oracle 12c's unified auditing features, highlighting the importance of auditing strategies to meet compliance requirements. The report focuses on the AUDIT_ADMIN and AUDIT_VIEWER roles, detailing their responsibilities in managing audit policies, viewing audit trails, and ensuring data security through monitoring database actions. It explains how these roles facilitate effective data analysis and auditing processes, ultimately enhancing an organization's ability to manage and control audit records to prevent data loss. The report references key sources to support the analysis, concluding with the significance of database auditing in securing data and monitoring user activities within a database environment. The report also explains how the AUDIT_VIEWER role allows users to analyze and audit data effectively, thereby improving the viewing of data without challenges. The Oracle 12c has made efforts by coming up with both AUDIT_ADMIN and AUDIT_VIEWER roles as it helps users in carrying out different activities.

Running Head: DATABASE SECURITY 1
Database Security
Name of Student
Name of Supervisor
Course Affiliated
Date

DATABASE SECURITY 2
Executive Summary
Ensuring the security of information is essential to any organization. Analyzing database
security measure is necessary to ensure efficiency. It’s critical to design auditing strategies to
provide information stored to meet the compliance requirements. Oracles for an extended period
have provided user protection. Unified auditing is responsible helps in consolidating auditing to a
single repository.

DATABASE SECURITY 3
Roles of AUDIT_ADMIN and AUDIT_VIEWER
Unified Auditing features are some of the improvement made by Oracle 12c. Auditing
involves examining financial records while determining the financial position of a Business.
Database auditing consists of analyzing the database to assess data accessed by administrators,
consultants, and other database users in an organization. Unified Auditing ensures all trial data is
standardized and streamlined. It also provides that one can run reports analysis for a set of data in
a single operation. The Oracle 12c performs two specific roles in managing data in the database.
First, the AUDIT_ADMIN helps in ensuring that the audit policies created, altered, and dropped.
It also provides that the various audit policies are disabled or enabled for the different business
requirements to view and clean-up the audit trail records (ZHANG & CHEN, 2017).
The AUDIT_VIEWER is used by users who want to view the audit trail contents.
Database auditing provides security for databases through recording and monitoring the
configured database actions by the database users and non-database users. These two roles make
it easy for the users to carry out varies types of editing of the database ("Database Upgrade Guide",
2019). Auditing procedures require AUDIT_ADMIN assistance. Therefore auditors are required
to edit different files after acquiring the AUDIT_VIEWER roles which are of great importance in
the process of Auditing.
The AUDIT_ADMIN and AUDIT_VIEWER provide privileges to the user through
creating unified, and excellent grained policies of the auditing process. The users are allowed to
view data effectively and therefore manage the auditing process accordingly. It is only the
trusted users will be able to enjoy the roles as that will again provide security to the systems.
Salama (2019), stated that,” A unified audit trail ensures that the audit information is consistently
formatted and contains consistent fields”

DATABASE SECURITY 4
The AUDIT_VIEWER is responsible for giving room for users to analyze and audit the
data effectively and thus bringing about the viewing of the data without having to experience a
lot of challenges. Oracle 12c has made efforts by coming up with both AUDIT_ADMIN and
AUDIT_VIEWER roles as it helps users in carrying out different activities. The audit
configuration and the audit trail administration facilitated through the introduction of the two
parts of AUDIT_ADMIN and VIEWER; hence, it ensures users can edit the data effectively. It is
stated that “Auditing is the monitoring and recording of configured database actions form both
the users” (Us, Clients, Now & Us, 2019).
To conclude, the Auditing and analysis of data facilitated by AUDIT_ADMIN and
AUDIT_VIEWER, and therefore, useful data analysis achieved in different means. Thus, the
faster Auditing is done by giving users rooms to improve their information sector within the
organization. The Oracle database ensures audit records are managed and controlled to prevent
data loss. The audit records are, therefore queued to the systems’ memory to reduce and avoid
the damages on data. Finally, the database auditing is the ability to monitor and observe the
activities carried out by the users within the database. The database auditing is carried out to
bring about security to the systems hence securing the data handled by the users.

DATABASE SECURITY 5
Reference
Database Upgrade Guide. (2019). Retrieved from https://docs.oracle.com/en/database/oracle/oracle-
database/12.2/upgrd/unified-auditing-audit_admin-audit_viewer-changes.html
Salama, T. (2019). Oracle Database 12c Security: New Unified Auditing. Retrieved from
https://blogs.oracle.com/imc/oracle-database-12c-security:-new-unified-auditing
Us, A., Clients, R., Now, O., & Us, C. (2019). Oracle 12c – Two New Roles – AUDIT_ADMIN And
AUDIT_VIEWER. Retrieved from https://precisionessays.org/oracle-12c-two-new-roles-
audit_admin-and-audit_viewer/
ZHANG, X., & CHEN, H. (2017). Audit Design Based on Protocol Analysis of ORACLE
Database. Destech Transactions On Computer Science And Engineering, (aics). doi:
10.12783/dtcse/aics2016/8208