Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h9NMNdG19527 for ; Thu, 23 Oct 2003 17:23:39 -0500 X-ClientAddr: 66.27.56.213 Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h9NMNdc19522 for ; Thu, 23 Oct 2003 17:23:39 -0500 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id h9NJZip10643 for oracle-l@orafaq.net; Thu, 23 Oct 2003 12:35:44 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D4208; Thu, 23 Oct 2003 12:34:26 -0800 Message-ID: Date: Thu, 23 Oct 2003 12:34:26 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Reginald.W.Bailey@jpmorgan.com Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Reginald.W.Bailey@jpmorgan.com Subject: Re: stop compile Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You might try using Fine Grained Access or a database level trigger that fires upon altering of a table. Also look into auditing the objects. To prevent a stored program from being compiled during business hours you can simply remove all object privileges from the the object so that no one will be granted any privileges on the object. If it is a production environment, hopefully the users or application only connect via a run-time userid, and not the schema owner. Then you could revoke object privileges from the run-time userid. You could always switch the stored program to another userid. Or drop the stored program and reimport it after hours. This would also compile it. RWB ============================================================================================================ Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) reginald.w.bailey@jpmorgan.com baileyre@us.ibm.com ============================================================================================================ oramagic@hotma il.com To: ORACLE-L@fatcity.com Sent by: cc: ml-errors@fatc Subject: stop compile ity.com 10/23/2003 02:04 PM Please respond to ORACLE-L is there any way trigger I can write so that no body can compile object (package/procedure) and alter table during business hours in 8.1.7.4 db. -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Reginald.W.Bailey@jpmorgan.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).