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
Received on Sun Jun 04 2000 - 10:09:44 CDT
