Re: Dropping user with logged in sessions

hasta_l3_at_hotmail.com wrote:
> Dear group,
>
> I must write an automated procedure to drop
> an Oracle user/schema (cascade)
>
> The procedure must succeed even if client apps
> are connected for that schema.
>
> Some clients perform automatic reconnection,
> and will quickly ( < 30 secs) try to reconnect
> if they find that the connection is lost.
>
> What is in your opinion the most foolproof
> way to implement this ?
>
> Thanks much
>
> --- Raoul
>
> Oracle 8.1.7.3 and 9.2.0.4
> Client connections are over TCP/IP
> W 2000/2003
>

What does the application end user expect to see during this operation? If I were using the app and got an Oracle error message during this operation, I'd be cursing the database.

Why do you want to drop the database objects? What does this achieve for you?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown