triggers -- that do an insert into an auditing table. Been there, done that:
Insert -- add a row to the auditing table of all the new values with one extra column "type" =I Delete add a row to the auditing table with all the old values and type=D Update -- add two rows to the auditing table -- first with old values and type = O second with all the new values and type =N --- "Foelz.Frank" <[EMAIL PROTECTED]> wrote: > TNX for your answers. > > What I need is exactly what Oracle doesn't support. Logging "who" > changed > "what" in a > special area of our database. > > I think triggering the events will be much more specific and more > easy to > change. > > In case all our applications use the same database and user, I am > trying to > check out > what application is changing monitored tables (i.e. > c:\app\userapp\app.exe > is changing > table1). > What do you think of that ?? > > greets > > > Frank < > > > >Von: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > > > >what sort of information are you looking to audit? if you want any > >sort of detail, you are better off with triggers and possibly an > audit > >table. Oracle doesn't record WHAT has been changed, just that the > >table was accessed. So you don't know the row etc... > > > > > >--- "Foelz.Frank" <[EMAIL PROTECTED]> wrote: > >> Hi all, > >> > >> does anyone have experience in using Oracle's possibilities of > >> auditing > >> a database ?? > >> > >> I am interested in performance questions i.e. is it a hughe loss > of > >> performance > >> when auditing tables Inserts/Updates/Deletes. Should I use > triggers > >> instead > >> ? > >> > >> any hints (comments, websites, etc...) are welcome. > >> > >> > Frank < > >> -- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Foelz.Frank > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
