Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    128

    Unanswered: Unable to audit.

    10g
    RHEL 4

    Howdy all. I am attempting to audit when people run ALTER TABLE statements and having a tough time. From reading docs and a book, it would appear that I would need to "alter system set audit_trail = db" before I can audit. However, when I try to run that I get "specified initialization paramter cannot be modified". I see this message when googling, but no clear resolution. I also see in a book that I should perhaps run "audit table" and then bounce the system. I do that, but then run "select * from dba_audit_trail" and it returns no records even though I've changed a table.

    Can someone please assist?

    TIA, cfr

  2. #2
    Join Date
    Nov 2004
    Posts
    128
    alter system set audit_trail=db scope=spfile

    made it work.

Posting Permissions

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