ORACLE用户创建及删除

– 0.创建表空间 1G
create tablespace TS_JG_DATA
DATAFILE ‘/oradata/shine/TS_JG_DATA.dbf’
SIZE 1024M;
– 1.创建用户
CREATE USER union_test IDENTIFIED BY union_test
DEFAULT TABLESPACE TS_JG_DATA;
– 2.给用户配置权限
GRANT CONNECT,RESOURCE TO union_test;
– 3.修改密码
alter user union_test identified by union_test01 ;
– 4.删除用户及表空间
drop user union_test cascade;
DROP TABLESPACE TS_JG_DATA INCLUDING CONTENTS AND DATAFILES; – 删除非空表空间，包含物理文件
– 删除用户提示正在连接时，杀进程
select username,sid,serial#,state from v$session where username=‘UNION_TEST’; – username大写
alter system kill session ‘225,39699’; – 杀不掉进程在最后加 immediate