Re: ORA-01940: cannot drop a user that is currently connected
- From: Bill Zakrzewski <bill@xxxxxxxxxxxx>
- To: mayurpnagarsheth@xxxxxxxxx
- Date: Wed, 6 Oct 2010 10:53:17 -0400
Have you (are you able to?) bounced the database and then attempt to drop the
user?
On Oct 6, 2010, at 10:46 AM, mayur nagarsheth wrote:
> This user account has been locked since 1 month. No active connections, no
> active sessions, no db links, no objects are being owned by this user. I
> revoked all the privileges this (ACOSTA) user had just to be on safer side.
> But nothing works :(
>
>
> On Mon, Oct 4, 2010 at 10:20 AM, Andy Klock <andy@xxxxxxxxxxxxxxx> wrote:
>
>
> On Mon, Oct 4, 2010 at 10:55 AM, mayur nagarsheth
> <mayurpnagarsheth@xxxxxxxxx> wrote:
> There are no jobs existing with these users. Also, it is not on RAC.
>
>
>
> That is a strange one. Not knowing how your database is set up, is it
> possible that ACOSTA connects periodically? Could you try locking the
> account, then do the delete?
>
> alter user acosta account lock;
>
>
>
> --
> Thanks n Regards,
> Mayur Nagarsheth
> Cell : (+1)214-364-8271
> http://www.linkedin.com/in/mayurnagarsheth
>
> http://lyle.smu.edu/~mnagarshet/
>
Other related posts:
