Locking production PL/SQL stored procedures
From: Daniel Pinol <dpinol_at_cesca.es>
Date: 1997/05/30
Message-ID: <338ED295.52DCD22A_at_cesca.es>#1/1
Date: 1997/05/30
Message-ID: <338ED295.52DCD22A_at_cesca.es>#1/1
Hi,
do you know any way to lock PL/SQL packages?
I have a production environment on user PROD, and I'm developing
next release of the application on user DEV. But I'm afraid I could
connect by mistake to PROD, and spoil the system that is on
production.
I tried revoking the grant RESOURCE to PROD (it contains
CREATE PROCEDURE). Then, I cannot create new procedures, but I
still can 'CREATE or REPLACE' or DROP packages.
Any suggestion?
Thanks,
I'll apreciate aan email to dpinol_at_cesca.es
Received on Fri May 30 1997 - 00:00:00 CEST
