Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    136

    Unanswered: To show all changes on the database

    Hi All!

    How can i list all accesses or all changes on my database?
    E.g.:

    User1 deleted on 2004-05-27 record2 in the table3


    and so on?

    It would be great anyone could help me!

    Thanks in advance!
    Regards,
    Julia

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    turn on Oracle Auditing

    you could also look into Log Miner for previous actions that happened before
    you turned Auditing on.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    136
    Hello Duck!

    Can you tell me please, how can i realize it?

    Thank you!
    Regards,
    Julia

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    realize what? I am confused.

    Do you mean:
    How do I turn on Auditing?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    136
    yes. What is it?
    Regards,
    Julia

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    this looks like the correct document:
    Code:
    http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/audit.htm#13630
    sepecifically look under:
    Enabling and Disabling Auditing
    Last edited by The_Duck; 08-11-04 at 11:41.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    Feb 2004
    Location
    Eternity
    Posts
    31

    Audit Trail

    U can set the audit trail on by setting a initialization parameter
    AUDIT_TRAIL = TRUE and then restart the DB
    Once u have set the audit trail to true u can find the audit trail by querrying for the table SYS.AUD$.
    Make sure that u periodically remove audit records from the audit trail with the DELETE or TRUNCATE command. Audit files are located in $ORACLE_HOME/rdbms/audit directory by default
    Last edited by spvijay; 08-11-04 at 11:56.
    Obviousness is the enemy of Correctness
    --Bertand Russel

  8. #8
    Join Date
    Jul 2003
    Posts
    2,296
    I also noticed Oracle can write directly to an O/S file instead of internally.
    That might be handy.

    Interesting stuff.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  9. #9
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    136
    Thank you very much!

    I try to realize it , it's some difficult because i'm just a normal user,
    i'll post the answer when it'll work.
    Regards,
    Julia

Posting Permissions

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