Xref: alice comp.databases.oracle.server:48404 Path: alice!news-feed.fnsi.net!netnews.com!newsfeed.enteract.com!newsfeed.mathworks.com!newsfeed1.earthlink.net!nntp.earthlink.net!posted-from-earthlink!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: Trigger on SYS tables ? Date: Wed, 05 May 1999 22:40:18 -0400 Content-Transfer-Encoding: 7bit References: <7gmr2p$3hk@router.kamsoft.com.pl> <372f5202.3805981@news.siol.net> X-Posted-Path-Was: not-for-mail X-Accept-Language: en Content-Type: text/plain; charset=us-ascii X-ELN-Date: 6 May 1999 02:38:40 GMT X-ELN-Insert-Date: Wed May 5 19:45:04 1999 Organization: EarthLink Network, Inc. Lines: 37 Mime-Version: 1.0 Message-ID: <37310112.D530432E@earthlink.net> X-Mailer: Mozilla 4.51 [en] (X11; I; SunOS 5.6 i86pc) Jurij Modic wrote: > > On Tue, 4 May 1999 14:58:37 +0200, "Jarek Palka" > wrote: > > >I'd like to add additional info (comment) to Oracle users. Is it possible to > >do some action on adding or dropping Oracle users ? I tried create trigger > >on USER$, DBA_USERS but it is wrong way, because making trigger on SYS > >objects is not allowed. May be ther is another way to do it? > > Not prior to Oracle8i (8.1.*). In 8i there are two new types of > triggering events that can be used: database events (like startup, > shutdown, logon, logoff) and ddl events (create, drop, alter > statements). > > The only option on pre-8i would be to move AUD$ table from schema SYS > to schema SYSTEM, turn on the auditing on desired events and then > attach trigger to SYSTEM.AUD$. But this solution is officially > unsupported by Oracle. Or to add it to catproc.sql file. Needles to say, it's not supported either. > > >Jarek Palka > >KAMSOFT, Katowice > >POLAND > > HTH, > Jurij Modic > Certified Oracle7 DBA (OCP) > ================================================ > The above opinions are mine and do not represent > any official standpoints of my employer -- Mladen Gogala