Results 1 to 4 of 4

Thread: Audit feature

  1. #1
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81

    Unanswered: Audit feature

    Hi,

    I am looking for info about auditing my tables.
    I have to see when each line of some of my tables was updated.

    I'd like not to use triggers for that purpose.

    Does anyone knows on how Fine-Grained Audit works ?
    Whether it uses triggers or it has some special way of work ?
    Last edited by kukuk; 05-29-03 at 11:16.
    --
    kukuk

  2. #2
    Join Date
    May 2003
    Posts
    87

    Re: Audit feature

    AUDIT command lets you do that. And if you want to get further deep into auditing & security, check chap 11 Establishing Security Policies of Oracle8i Application Developer's Guide - Fundamentals.

    http://download-west.oracle.com/docs...g12sec.htm#403

    Originally posted by kukuk
    Hi,

    I am looking for info about auditing my tables.
    I have to see when each line of some of my tables was updated.

    I'd like not to use triggers for that purpose.

    Does anyone knows on how Fine-Grained Audit works ?
    Whether it uses triggers or it has some special way of work ?

  3. #3
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81
    Great, thank you.
    How can I know whether this feature uses old good triggers or not ?
    --
    kukuk

  4. #4
    Join Date
    May 2003
    Posts
    87
    Might be .. might be not ! But since it is handled by the db architecture, the performance is much much better than writing triggers.

    But yes, AUDIT will kind of slow things down.

    Originally posted by kukuk
    Great, thank you.
    How can I know whether this feature uses old good triggers or not ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •