ORACLE 创建表空间、用户、授权

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;