oracle创建用户

创建表空间

1.表空间

CREATE TABLESPACE zy  
DATAFILE 'D:\app\oracle\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\database\storage\tablespace\zy' size 800M  
         EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;   

–2.建用户

create user zy identified by zy   
default tablespace zy;  

–3.赋权

grant connect,resource,dba to zy; 

注意：不知道表空间位置，可以先查看别的表空间的位置

SELECT * FROM Dba_Data_Files ddf WHERE ddf.tablespace_name = 'USERS';

---

不创建表空间

--1.**建用户**  
create user zy identified by zy;  

--2.**赋权**  
grant connect,resource,dba to zy;