ORACLE創建表空間、用戶、授權

1、創建表空間

create tablespace TEST
logging
datafile 'e:\app\administrator\oradata\orcl\TEST.dbf'
size 100M
autoextend on
next 100M maxsize 4096M
extent management local;

create use testuser identified by password
default tablespace TEST
temporary tablespace temp;

grant connect  to testuser;
grant dba to testuser;
grant role to testuser;