Re: Dropping user with logged in sessions

On 6 fév, 11:26, "Johan" <sjefk..._at_hotmail.com> wrote:
> On 6 feb, 06:39, hasta..._at_hotmail.com wrote:
>
>
>
> > Dear group,
>
> > I must write an automated procedure to drop
> > an Oracleuser/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 allsessionsand drop theuser.
>

Thanks, Johan.

ALTER USER ACCOUNT LOCK is what I was after Received on Tue Feb 06 2007 - 09:52:06 CST