Re: Auditing

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 8 May 2007 14:18:43 -0700
Message-ID: <bf46380705081418i50cd2ba9h15f9528810ef5844@mail.gmail.com>

According to that, the 'by user' syntax only works with generalized auditing.
eg. audit select table by scott

Attempting to do 'audit select on x by scott' results in an error;

14:17:46 sql>/
audit select table on x by scott

                   *

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

14:17:46 sql>audit select table by scott;

Audit succeeded.

14:17:55 sql>audit select on x;

Audit succeeded.

14:17:58 sql>

The documentation for audit in the SQL manual would seem to suggest otherwise.

On 5/8/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> This might be helpful:
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c25audit.htm#638
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Richard J. Goulet
>
>
> But good old sqlplus keeps asking for "by access or session?". Anyone
> got an idea where I'm going wrong?? BTW this is Oracle 9.2.
>
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 08 2007 - 16:18:43 CDT