Lock user, kill all connected sessions, drop user. Otherwise, someone
can be connected just before you drop it.

2006/7/5, Laimutis Nedzinskas <Laimutis.Nedzinskas@(protected)>:
> Anything I can do but bounce the database?

--
Best regards,
Alex Gorbachev

http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l