Unanswered: Audit Feature in Oracle9i - To enable for a User
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.