[RastogiKamesh]

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.

Regards,

[aarroyob]

http://download-west.oracle.com/docs...8a.htm#2060025

Cheers