ORACLE 创建表空间、用户、授权
时间:2022-03-14 01:42
1、创建表空间
create tablespace TEST logging datafile ‘e:\app\administrator\oradata\orcl\TEST.dbf‘ size 100M autoextend on next 100M maxsize 4096M extent management local;
2、创建用户并指定表空间
create use testuser identified by password default tablespace TEST temporary tablespace temp;
3、授权
grant connect to testuser; grant dba to testuser; grant role to testuser;
ORACLE 创建表空间、用户、授权,布布扣,bubuko.com