Audit SELECT

Tagged: ,

This topic contains 2 replies, has 0 voices, and was last updated by  ramaral 10 years, 10 months ago.

  • 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.

You must be logged in to reply to this topic.