New Auditing roles in Oracle 12c

Write an essay of at least 500 words discussing the reasons for the two new auditing roles in Oracle 12c. Why did Oracle consider them necessary? What problems do they solve? How do they benefit companies? 

Do not copy without providing proper attribution. This paper will be evaluated through SafeAssign. 

Write in essay format not in outline, bulleted, numbered or other list format.  

Use the five paragraph format. Each paragraph must have at least five sentences. Include 3 quotes with quotation marks and cited in-line and in a list of references. Include an interesting meaninful title.

Include at least one quote from each of 3 different articles. Use the 

Research Databases available from the Danforth Library

, not Google.   Place the words you copied (do not alter or paraphrase the words) in quotation marks and cite in-line (as all work copied from another should be handled). The quotes should be full sentences (no more, less) and should be incorporated in your discussion (they do not replace your discussion) to illustrate or emphasize your ideas.

Cite your sources in a clickable reference list at the end. Do not copy without providing proper attribution (quotation marks and in-line citations).

4

Bhargav Choudary Alaparthi

New England college

01/10/2021

Oracle has introduced unified auditing which enables effective and selective accounting for the oracle database using specified conditions and policies. The new policy has a syntax base that simplifies auditing management within the database and gives audit ability to accelerate auditing connections like proxy authentication. The need for separation of special schemas from auditing when enabling audit policies. On the other hand, ‘conditional auditing was necessary for highly selective logging that minimizes log entries to specific events such as particular SQL statements including the actions CREATE and ALTER originating from outside specific servers identified by IP address’ (Groomer & Murthy, 2018).

Oracle regarded the new auditing roles as necessary simply because the recording and monitoring of databases for users and non-users is done carefully. The actions of the database users are determined by auditing the database. The administrators of the database have set auditing to ensure the security of the information so that unauthorized users cannot access the company’s data without permission (Groomer & Murthy, 2018). The database auditing enables the company to control, check, and manages the activities of the database users. The auditing of the database enables the users of the database to responsible and accountable for the course of actions. The audit enables the administrators and auditors to get alerts when an unauthorized person deletes files or changes the file or the user has some other rights than the granted.

The auditing has solved the issue of data insecurity because the company has installed a client identifier that enables the administrators of the database to recognize the non-database users. This guarantee the confidentiality of the information and data of the company thus guarantying the security of database users’ information. The auditing has facilitated the separation of the responsibilities in the auditing process (Groomer & Murthy, 2018). The roles of connecting sysdba and dba role work independently of each other. Auditing also enables the organization to determine which organization of auditing are a failure and those which are successful thus making the audit performance to be well known.

The new role of auditing has made the performance to be a bit faster as compared to the earliest forms of auditing .the auditing of the data has made it easier in controlling the audit records as records are written in the audit trail (Ravikumar et al.,2017). The records easily queued in the memory immediately. The audit has enabled the simplification of configuration auditing of the database during the auditing process. Auditing of the database is extremely flexible than any other time. The flexibility posters faster operations during the auditing process as it is adaptable to changes in the audit environments. The auditors are allowed to remove audit configuration or include their configuration for objects in schemas without additional privileges. ‘AUDIT _ADMIN helps in viewing and analyzing, which is the primary role of security administrator’ (Ravikumar et al., 2017). The new auditing roles have given external auditors and the internal auditors to view the audit data after receiving the audit viewer role. This includes granting the executive privilege on the packages.