Re: how to disable Stored procedure

Rangesh,
I don't think it can be done easily.
If procedures are accessing tables in another schema, then revoking access to these tables should do. But if they are accessing tables in the same schema you have to find something they depend on and somehow damage these objects...

In any case, Oracle tries to re-compile invalid objects "on the fly", so even if you can find a way to invalidate all objects in a schema, an attempt to use any of them will automatically lead to re-compillation. If all objects a procedure depends on have not been changed and all privileges are still in place, the procedure will be re-compilled.

What exactly are you trying to achieve? Received on Fri Jan 24 2003 - 04:09:08 CST