Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: Audit Feature in Oracle9i - To enable for a User

    Hi Everyone,
    I am using Oracle9i on SUN OS - Solaris5.8. I have enabled the AUDIT_TRAIL=DB in my init<SID>.ora file. I would like to enable specific audit option for a particular user. I am giving this command in my sys schema to enable the audit:

    SQL> audit INSERT TABLE on <UserName>; I am getting this error message and not able to do it: The error is::

    ERROR at line 1:
    ORA-00933: SQL command not properly ended

    Basically i would like to have audit enabled for all insert command being executed by <UserName>. COuld any one help me please as how to do it.

    Thanks in advace.

    - KR

  2. #2
    Join Date
    Apr 2003

Posting Permissions

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