Re: Dropping user with logged in sessions

On 6 feb, 06:39, hasta..._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

First lock the account, then kill all sessions and drop the user.

Regards, Johan Received on Tue Feb 06 2007 - 04:26:28 CST