Audit SELECT

Tagged: ,

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #1876
      ramaral
      Participant

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

    • #2028
      Saurabh Sood
      Member

      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

    • #2029
      Amit Bansal
      Keymaster

      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.

Viewing 2 reply threads
  • You must be logged in to reply to this topic.