2017년 7월 10일 월요일

create user & tablespace with oracle

create tablespace gass_table datafile 'c:\oracle\product\11.2.0\dbhome_1\oradata\gass\gass_table.dbf' size 100m;

create user muse identified by password default tablespace gass_table profile default quota unlimited on gass_table account unlock;

grant resource, connect to muse;
grant create view, create synonym to muse;

댓글 없음: