Audit SELECT Tagged: audit, select This topic contains 2 replies, has 0 voices, and was last updated by ramaral 10 years, 10 months ago. Author Posts 28 October, 2008 at 12:17 pm #1876 ramaralParticipant How to Audit select’s in the database 10g Standard. FGA does not work and triggers only for insert, delete, update. 6 November, 2008 at 9:58 am #2028 Saurabh SoodMember Hi, In Standard edition you do not have the option of FGA. You can simply set the audit_trail parameter and try to audit normally. If it fails, please show us the method you used. Cheers!!!! Saurabh 7 November, 2008 at 5:23 am #2029 Amit BansalKeymaster Hi, 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. In case of FGA ,we can do fine grained auditing i.e we can define filters and also do auditing at column level. Author Posts You must be logged in to reply to this topic.