Auditing

From: Richard J. Goulet <rgoulet_at_kanbay.com>
Date: Tue, 8 May 2007 15:02:07 -0400
Message-ID: <C3EE2ADD31ACF64DAB1B236044A1968D730ACD@miaexc01.kanbay.com>

Folks, I'm having a brain meltdown on this one and I'm 99% certain it's something really dumb that I'm trying to do, so please do a critique for me.  

    I'm trying to audit select, insert, update, and delete on a pile of schema objects by a handful of users. The following statement seems correct to me:  

    audit select, insert, update, delete on scott.emp by user1, user2 whenever successful;  

    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.  

........................................................................


............................................................. 

Kanbay <http://www.kanbay.com/>
Dick Goulet, Senior Oracle DBA
45 Bartlett ST | Marlborough, MA 01752 USA Tel: 508.573.1978 | Fax: 508.229.2019 | Cell: 508.742.5795

rgoulet_at_kanbay.com <mailto:rgoulet_at_kanbay.com> 
........................................................................


............................................................. 



 

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

Received on Tue May 08 2007 - 14:02:07 CDT