Oracle 用户创建、删除操作

1、创建：

create tablespace PANDORA_ADMIN datafile 'PANDORA_ADMIN_TABLESPACE.dbf' size 500M autoextend on next 5M maxsize unlimited;
create user PANDORA_ADMIN IDENTIFIED BY "1qazzaq1" default tablespace PANDORA_ADMIN temporary tablespace TEMP profile DEFAULT;
grant connect,resource,create session,create table,unlimited tablespace to PANDORA_ADMIN;

 

2、删除：

drop user PANDORA_ADMIN cascade;
drop tablespace PANDORA_ADMIN including contents and datafiles cascade constraint;