Oracle数据库添加用户,设置权限，删除用户

//创建用户

create user thtwin identified by thtwin

//给用户授权

grant create session to thtwin

grant create table to thtwin

grant unlimited tablespace to thtwin

//删除用户

drop user thtwin cascade

ALTER USER STORE ACCOUNT LOCK

--查询进程号(sid,serial#)

select* FROM v$session WHERE username='STORE'

--删除对应的进程

ALTER SYSTEM KILL SESSION '862,3566'

--删除对应的用户

DROP USER STORE  CASCADE