Oracle-L: Re: stop compile

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Thu, 23 Oct 2003 12:34:26 -0800
Message-ID: <F001.005D4208.20031023123426@fatcity.com>

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_at_jpmorgan.com
baileyre_at_us.ibm.com

                                                                                                                            
                    oramagic_at_hotma                                                                                          
                    il.com               To:     ORACLE-L_at_fatcity.com                                                       
                    Sent by:             cc:                                                                                
                    ml-errors_at_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_at_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_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 Thu Oct 23 2003 - 15:34:26 CDT