| 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: adding columns to system tables
please note you said "copies" :)
>From: Jared Still <jkstill_at_cybcon.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: adding columns to system tables
>Date: Mon, 21 May 2001 13:36:23 -0800
>
>
>While this practice would be frowned on, I have had occasion
>to do something similar myself.
>
>Developers were required to have the ability to see source
>code in stored procedures in production instances through
>SQL Navigator, without granting the database privileges that
>would normally make this possible.
>
>Please don't lecture me on change control on this, the damagers
>backed the developers on this and we had no choice. We tried
>to sell them on the virtues of competent change control. But that
>requires competent duhvelopers.
>
>But I digress.
>
>My solution was to create modified copies of ALL_OBJECTS and
>ALL_SOURCE named ALL_OBJECTS2 and ALL_SOURCE2. The
>developers in question had private synonyms named ALL_SOURCE
>and ALL_OBJECTS that pointed to the modified objects.
>
>The developers were happy, the damagers were happy, and I was
>happy for having something interesting to do.
>
>I wouldn't recommend doing this except in extreme circumstances
>such as this though, and not for support reasons, but because modifying
>these views is *extremely* difficult and not for the faint of heart.
>
>They will also likely break after the next database upgrade.
>
>YMMV
>
>Jared
>
>
>
>On Friday 18 May 2001 09:25, Greg Schraiber wrote:
> > Does anyone know if it is 'safe' to add additional columns
> > to user_tab_columns? I am running 8.1.5. I would use the new
> > columns to tell the application software which columns on
> > any one table are user editable by a dynamically generated
> > dialog form.
> >
> > Thanks,
> > Greg
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jared Still
> INET: jkstill_at_cybcon.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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.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).Received on Mon May 21 2001 - 19:33:54 CDT
 |
 |