AskDBA.org Forum Forum for Oracle DBA's

About This Topic

• Posted 3 years ago
• By ramaral
• Latest reply from Amit Bansal
• This topic is not a support question
• RSS feed for this topic

Tags

• audit
• select

1. 

   ramaral
   

   new member
   Joined: Oct '08
   Posts: 1

   offline

   Reputation:2

    

   
   Posted 3 years ago
   #

   How to Audit select's in the database 10g Standard. FGA does not work and triggers only for insert, delete, update.
2. 

   Saurabh Sood
   

   admin
   Joined: Jun '08
   Posts: 46

   offline

   Reputation:48

    

   
   Posted 3 years ago
   #

   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

   Saurabh Sood
   Senior Consultant:DBA Services
3. 

   Amit Bansal
   

   Oracle DBA
   Joined: Jun '08
   Posts: 73

   offline

   Reputation:96

    

   
   Posted 3 years ago
   #

   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.

   Cheers
   Amit
   http://askdba.org/weblog/