Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Database Auditing

Posted on December 7th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

The Oracle database has sophisticated auditing capabilities and can audit virtually any action within the database. Oracle9i introduces Fine Grained Auditing which allows auditing down to the column level in queries. The Oracle database auditing features and Oracle Applications auditing features are completely separate mechanisms.

By default, only “Instance Startup”, “Instance Shutdown”, and connections to the database with administrator privileges are audited. Usually only session and database user auditing are enabled.

In the init.ora file, set the audit_trail parameter to true and restart the database.

From the SYSTEM user in SQL*Plus, execute the SQL AUDIT commands that coincide with your requirements.

Limitations:

  • Does not provide before and after values for column changes.
  • Audits are at the SQL statement level, they do not reflect the resulting impact to individual records and columns within a table.
  • Provides no standard reporting or access to data from a form.
  • Resulting data in the SYS.AUD$ table is not “end user” ready.
  • Because the table is owned by SYS, cannot provide an event based alert or notification to a user. (Cannot define a trigger on SYS tables.)

Related Posts

Posted in AOL | No Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.