New Auditing roles in Oracle 12c



Bhargav Choudary Alaparthi

New England college


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.