Re: Enbling and Diabling Table Triggers

Oracle does NOT maintain a history. You can turn auditing on on that trigger, and that will generate records in the AUD$ table that will track who and when the disable/enable the trigger was done.

In this case, that would give you enough information. For most dml statements, auditing doesn't give you enough, because it doesn't tell you what was changed.

Rachel

>From: Alroy Mascrenghe <mark_alroy_at_yahoo.co.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Enbling and Diabling Table Triggers
>Date: Mon, 05 Jun 2000 02:04:03 -0800
>
>Yes it definitely does. I checked it myself. Thanks.
>This will be pretty helpful.
>
>But does oracle maintain a history..i.e. during this
>time this trigger was disabled but later it was
>enabled..?
>
>Alroy
>
>--- Rachel Carmichael <carmichr_at_hotmail.com> wrote: >
>it probably does.... since it gets updated when you
> > grant a priv to
> > someone... that I DO know for a fact since it
> > screwed me up when I was
> > setting up some security checks to see who was
> > modifying objects in my
> > database.
> >
> >
> > >From: "Joseph S. Testa" <teci_at_oracle-dba.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > >Subject: Re: Enbling and Diabling Table Triggers
> > >Date: Sun, 04 Jun 2000 07:24:03 -0800
> > >
> > >just a guess(as i've not tested it) but does
> > last_ddl_time in
> > >sys.dba_objects get updated when a trigger is
> > enabled or disabled? I'm
> > >short on time or i'd checked it out to see.
> > >
> > >joe
> > >Alroy Mascrenghe wrote:
> > > >
> > > > Hi All
> > > >
> > > > Is there a way of knowing when a database
> > table/row
> > > > level trigger was disabled...? Does Oracle keep
> > any
> > > > log..?
> > > >
> > > > Alroy
> > > >
> > > >
> >
>____________________________________________________________
> > > > Do You Yahoo!?
> > > > Get your free @yahoo.co.uk address at
> > http://mail.yahoo.co.uk
> > > > or your free @yahoo.ie address at
> > http://mail.yahoo.ie
> > > > --
> > > > Author: =?iso-8859-1?q?Alroy=20Mascrenghe?=
> > > > INET: mark_alroy_at_yahoo.co.uk
> > > >
> > > > 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: 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).
> > >
> > >--
> > >Joe Testa http://www.oracle-dba.com
> > >Oracle 8i documentation online
> > http://www.oracle-dba.com/oracle-docs
> > >--
> > >Author: Joseph S. Testa
> > > INET: teci_at_oracle-dba.com
> > >
> > >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: 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).
> >
> >
>________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com
> >
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.com
> >
> > 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: 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!?
>Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
>or your free @yahoo.ie address at http://mail.yahoo.ie
>--
>Author: =?iso-8859-1?q?Alroy=20Mascrenghe?=
> INET: mark_alroy_at_yahoo.co.uk
>
>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: 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 Mon Jun 05 2000 - 08:06:44 CDT