oracle 创建表空间 创建用户 权限

使用dba帐户登入到数据库中执行以下语句

---创建临时表空间
create temporary tablespace cnp_temp  
tempfile 'E:\oracle\product\10.2.0\oradata\cnp\cnp_temp.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;

--创建表空间
create tablespace cnp_data  
logging  
datafile 'E:\oracle\product\10.2.0\oradata\cnp\cnp_data.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  

--删除创建的表空间
DROP TABLESPACE cnp_data INCLUDING CONTENTS AND DATAFILES;
DROP tablespace cnp_temp INCLUDING CONTENTS AND DATAFILES;


--创建用户和密码并设置表空间
create user cnp identified by blyl  
default tablespace cnp_data  ----用户的对象如果不指定都是放在这里
temporary tablespace cnp_temp  ---用户的操作如果要用到临时空间的话就在这里用

---删除用户
drop user cnp cascade;

---赋予权限,具体的权限需要根据实际情况赋予
---grant connect,resource,dba to cnp; 
grant connect,resource to cnp;
grant select on v_$statname to cnp; 
grant select on v_$sesstat to cnp; 
grant select on v_$session to cnp; 
grant select on v_$mystat to cnp; 
grant create any view to cnp;
grant create session to cnp;
grant debug any procedure, debug connect session to cnp;
--- 回收权限 
revoke dba from cnp;