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.