Oracle 使用sql创建表空间及用户

create tablespace OrcalDBNamedb datafile 'C:\OracleDBDirc\OrcalDBNamedb.dbf' size 300m;

创建用户
create user OrcalDBName identified by dbPwd default tablespace OrcalDBNamedb account unlock;

给用户授权
grant create table,create view,create trigger, create sequence,create procedure to OrcalDBName;
grant dba to OrcalDBName;