| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: {SPAM?} Re: {SPAM?} Re: fine grained access
Then AUDIT it is (we don't have 9) - thanks, Arup...
peter
edinburgh
>
> Are you interested to know whether a select statement ran againt a
> particular table, only? Then AUDIT command will do the job nicely.
>
> However, if you want to record 'what' was selected from that
> table, you need
> Fine Grained Auditing, which requires Oracle 9i.
>
> HTH.
>
> Arup Nanda
> www.prolignece.com
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, July 03, 2003 6:35 AM
>
>
> >
> > 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
> *********************************************************************
>
>> To REMOVE yourself from this mailing list, send an E-Mail message
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: orarup_at_hotmail.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). -- 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).Received on Fri Jul 04 2003 - 04:39:23 CDT
 |
 |