oracle 创建用户授权dba、创建表空间
1、查询表空间存放地址
SELECT * FROM Dba_Data_Files ddf WHERE ddf.tablespace_name = 'TablespaceName';
2、创建表空间
create tablespace SZYJ_WF
datafile 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SZYJ_WF.dbf'
size 500M autoextend on next 5M maxsize unlimited;
3、创建用户并授权
create user SZYJWORKFLOW identified by SZYJWORKFLOW;
alter user SZYJWORKFLOW default tablespace SZYJ_WF;
grant connect,resource,dba to SZYJWORKFLOW;
MrNou