http://www.forum.askdba.org/ Forum for Oracle DBA's en Thu, 09 Feb 2012 22:29:00 +0000 http://www.forum.askdba.org/topic/audit-select#post-30 Fri, 07 Nov 2008 05:23:50 +0000 Amit Bansal 30@http://www.forum.askdba.org/ <p>Hi,</p> <p>Just to add to Suarabh's reply. You can audit select's in database using schema level auditing. e.g audit select on employees will log selects on the employee table.</p> <p>In case of FGA ,we can do fine grained auditing i.e we can define filters and also do auditing at column level. </p> http://www.forum.askdba.org/topic/audit-select#post-29 Thu, 06 Nov 2008 09:58:58 +0000 Saurabh Sood 29@http://www.forum.askdba.org/ <p>Hi,</p> <p>In Standard edition you do not have the option of FGA.<br /> You can simply set the audit_trail parameter and try to audit normally.<br /> If it fails, please show us the method you used.</p> <p>Cheers!!!!<br /> Saurabh </p> http://www.forum.askdba.org/topic/audit-select#post-28 Tue, 28 Oct 2008 12:17:21 +0000 ramaral 28@http://www.forum.askdba.org/ <p>How to Audit select's in the database 10g Standard. FGA does not work and triggers only for insert, delete, update. </p>