ORA-01940: cannot drop a user that is currently connected

Cause:

As the to drop user is connected currently, let the user disconnect from the session

kIsH@x3z6zx9<^>!oerr ora 1940
01940, 00000, “cannot drop a user that is currently connected”
// *Cause: Attempt was made to drop a user that is currently logged in.
// *Action: Make sure user is logged off, then repeat command.

kIsH@x3z6zx9<^>drop user test cascade;
drop user test cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

Action:

Drop the user from admin or privileged user

kIsH@x3z6zx9<^>conn / as sysdba
Connected.
kIsH@x3z6zx9<^>drop user test cascade;

User dropped.

Leave a Reply