RE: recording SQLPlus activity

From: Ray Gordon <rgordon_1_at_hotmail.com>
Date: Tue, 25 Jun 2002 14:27:07 -0800
Message-ID: <F001.00487B28.20020625142707@fatcity.com>

Dennis,
You have hit the sore point. Developers start maintaining separate schemas, make schema changes, test their programs in this artificial schema, and then forget that nothin's going to work in the real development schema.

We want to seriously walk away from that. Single schema. We want developers to push changes via change control. Change controls will be aggressively addressed.

To try out something, they can always copy part of the development schema into their own "self maintained" schema or work area. But, this is not encouraged. We want the entire development team to work on a marching rhythm, everyone in synch. and on the same page.

SQL*Plus login.sql script: We are looking for a tamper proof solution, since it is for a bank. This wont work for several reasons. User may find a terminal without the login script, may alter the login script, may logon from home, etc.

Ray

>From : WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Reply-To : ORACLE-L_at_fatcity.com
To : Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject : RE: recording SQLPlus activity Date : Tue, 25 Jun 2002 12:45:16 -0800

Ray,

• Don't count out the idea of separate schemas. Your options to track what you are proposing is quite limited otherwise. Unfortunately, most things are tracked in Oracle only by userid. Someone on this list pointed out a way to have separate schemas pretty efficiently. Create a developer template, so you create the userid, grant the tables, and create private synonyms for the developer. The advantage is that if a developer needs to make a table change, and with this many developers you will be doing that a lot, you can let them drop the synonym and create the table in their schema until you are ready to roll the change out to the other developers.
• The only idea I have for doing what you the way you describe would be to use the SQL*Plus login.sql script so you configure some identity information automatically. You could even start a spool file that would track their activities, but the drawback is if they open a spool file, that would terminate your file.
• I liked your joke about your being in control of the development. With that many developers, control is about the last thing you'll have. :-)

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, June 25, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L

Dennis,
I dont want to create separate working environments for each of the users. We have had cases where developers compile programs in their programs and which do not work in the real environment, and several other issues.

Ideally, I would like to have everyone work in the same environment, but with controls.

Ray

---

MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Gordon
  INET: rgordon_1_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 Tue Jun 25 2002 - 17:27:07 CDT