oracle新建表空间、创建用户并授权

create tablespace cooperation_data  

logging  

datafile 'D:\oracle11\oradata\cooperation_data.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;  

 

/*第3步：创建用户并指定表空间  */

create user fengxz identified by fengxz  

default tablespace cooperation_data  ;  

 

/*第4步：给用户授予权限  */

grant connect,resource,dba to fengxz;