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/ >