Oracle 删除当前被连接的用户

Oracle 删除当前被连接的用户

select username,sid,serial# from v$session where username='aaa';

 

干掉Session
alter system kill session'128,12623';

删除用户
drop user aaa cascade;