Re: audit problems

"Michael Chang" <kc2592_at_cnsvax.albany.edu> writes:

> what are the correct steps to setup the audit to work?
> i set the audit_trail parameter to be TRUE.. execute the script
> CATAUDIT.sql..
> and then i created a simple audit statement: AUDIT SELETE TABLE BY user2..
> however, when i log on ORACLE as USER1, and do the SELECT statement, the
> action seems to be recorded also.. what am i missing here?? and which table
> do
> i see for the audit record?? sys.aud$ or user_audit_trial??
> thanks..
>
>

Did you bounce the database after setting the parameter? If not, you need to.

--

                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com

       The statements and opinions expressed here are my own and do not
             necessarily represent those of  Oracle Corporation.