先建立表空间,然后建立用户。
create table tablespace_name datafile '/oradata/a.dat' size 500m;create user user_name identified by user_name user_name default tablespace tablespace_name temporary tablespace temp ;
grant dba, connect, resource, create table to user_name ;
create table tablespace_name datafile '/oradata/a.dat' size 500m;create user user_name identified by user_name user_name default tablespace tablespace_name temporary tablespace temp ;
grant dba, connect, resource, create table to user_name ;
create user TESTUSER
identified by ""
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to TESTUSER with admin option;
grant dba to TESTUSER with admin option;
grant resource to TESTUSER with admin option;
-- Grant/Revoke system privileges
grant unlimited tablespace to TESTUSER with admin option;