步骤一、锁定用户 alter user xxx account lock;
步骤二、删除已建立线程
declare
vsql varchar(100);
begin
for a in(select sid,serial# from v$session where username='xxx') loop
vsql:='alter system kill session'''||a.sid||','||a.serial#||'''';
execute immediate vsql;
end loop;
end;
/
步骤三、删除用户
drop user xxx cascade;
步骤二、删除已建立线程
declare
vsql varchar(100);
begin
for a in(select sid,serial# from v$session where username='xxx') loop
vsql:='alter system kill session'''||a.sid||','||a.serial#||'''';
execute immediate vsql;
end loop;
end;
/
步骤三、删除用户
drop user xxx cascade;