Oracle 创建新用户

--创建表空间,【注意修改】一下物理路径。
create tablespace SD_WF
logging
datafile 'D:\dataBase\oracledata\SD_WF.dbf'
size 500m
autoextend on
next 50m maxsize 20480m
extent management local;

---创建用户
-- Create the user
create user SD_WF
identified by SD_WF
default tablespace SD_WF
temporary tablespace TEMP;


-- Grant/Revoke role privileges （权限）

grant DBA to SD_WF;
grant connect to SD_WF;
grant resource to SD_WF;