Re: Audit problem - could you help?

James Dickson - SERCO wrote:
>
> I am attempting to set up auditing for the first time.
> I tried to turn on auditing for the following, which
> according to the Oracle admin manual (tables 13-1 & 13-2)
> are all valid options:
>
> CREATE TABLE
> TRUNCATE TABLE
> DROP TABLE
> ALTER TABLE
> DELETE TABLE
> GRANT TABLE
> INSERT TABLE
> LOCK TABLE
> UPDATE TABLE
>
> Most options work, e.g.
> >AUDIT CREATE TABLE BY SESSION;
> >Audit succeeded.
>
> For some reason the DROP and TRUNCATE options refuse to be set;
> instead I get the error:
> AUDIT TRUNCATE TABLE BY SESSION
> *
> ERROR at line 1:
> ORA-00956: missing or invalid auditing option
>
>
> Any help appreciated.
> Replies by email preferred James.Dickson_at_mail.esrin.esa.it
>
> ThanksTry using: AUDIT TABLE BY SESSION; This should include CREATE, ALTER, and
DROP. As far as TRUNCATE goes, I think you use AUDIT TRUNCATE BY SESSION; I don't think you have to specify TABLE.

-- 
-------------------------------------------------
Ken Johnson -  Technical Consultant
Tapestry Computing, Inc. http://www.tapestry.com