A particular select? or just any select? I think you can use Oracle
auditing if that's all you need.
- "Robson, Peter" <pgro_at_bgs.ac.uk> wrote:
>
> Interesting threads.
>
> May I just seek the advice of the list on the alternative means by
> which one
> might capture read only activity? We want to know if a 'select'
> statement is
> run against particular tables.
>
> peter
> edinburgh
>
> > -----Original Message-----
> > From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]
> > Sent: 02 July 2003 16:46
> > To: Multiple recipients of list ORACLE-L
> > Subject: {SPAM?} Re: fine grained access
> >
> >
> > Fine grained access control doesn't tell you who did what, it
> > restricts
> > users from doing certain things.
> >
> > If you want to just capture the changes, not the actual update
> > statement, you can do this via triggers which insert into a
> > copy of the
> > table, with the additional columns of timestamp and user
> >
> > --- GKor_at_rdw.nl wrote:
> > > Hi list
> > >
> > > We have a dozen authorisation tables who are visibible for
> end-users
> > > and
> > > changeable for application owners.
> > > What our security officer wants is that he can see who changed
> > > something in
> > > those tables (including timestamp and update statement)
> > > Is FGA the solution for this ?
> > > Anyone with a few tips/hints how to do this with FGA ?
> > >
> > > thanks
> > >
> > >
> > >
> > >
> > > vr.gr.
> > > Geo Kor
> > > Sr. System Engineer I&DM Db
> > > RDW Voertuiginformatie en -toelating
> > > Ict Bedrijf
> > > Holland
> > > * gkor_at_rdw.nl
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author:
> > > INET: GKor_at_rdw.nl
> > >
> > > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > > San Diego, California -- Mailing list and web
> > hosting services
> > >
> >
> ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
> in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You
> may
> > > also send the HELP command for other information (like
> subscribing).
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_at_yahoo.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting
> services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like
> subscribing).
> >
>
>
> *********************************************************************
> This e-mail message, and any files transmitted with it, are
> confidential and intended solely for the use of the addressee. If
> this message was not addressed to you, you have received it in error
> and any copying, distribution or other use of any part of it is
> strictly prohibited. Any views or opinions presented are solely those
> of the sender and do not necessarily represent those of the British
> Geological Survey. The security of e-mail communication cannot be
> guaranteed and the BGS accepts no liability for claims arising as a
> result of the use of this medium to transmit messages from or to the
> BGS. . http://www.bgs.ac.uk
> *********************************************************************
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Robson, Peter
> INET: pgro_at_bgs.ac.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Jul 03 2003 - 09:30:50 CDT