--建三个用户
create user loc_emos_routine identified by Emos_2018;
create user loc_emos_common identified by Emos_2018;
create user loc_emos_sec identified by Emos_2018;
create tablespace loc_emos_common datafile 'C:\Oracle\oradata\orcl\LOC_EMOS_COMMON.DBF' size 100m autoextend on next 32m maxsize 2048m;
create tablespace loc_emos_routine datafile 'C:\Oracle\oradata\orcl\LOC_EMOS_ROUTINE.DBF' size 100m autoextend on next 32m maxsize 2048m;
create tablespace loc_emos_sec datafile 'C:\Oracle\oradata\orcl\LOC_EMOS_SEC.DBF' size 100m autoextend on next 32m maxsize 2048m;
grant connect to loc_emos_routine;
grant create indextype to loc_emos_routine;
grant create job to loc_emos_routine;
grant create materialized view to loc_emos_routine;
grant create procedure to loc_emos_routine;
grant create public synonym to loc_emos_routine;
grant create sequence to loc_emos_routine;
grant create session to loc_emos_routine;
grant create table to loc_emos_routine;
grant create trigger to loc_emos_routine;
grant create type to loc_emos_routine;
grant create view to loc_emos_routine;
grant unlimited tablespace to loc_emos_routine;
alter user loc_emos_routine quota unlimited on loc_emos_routine;
grant connect to loc_emos_common;
grant create indextype to loc_emos_common;
grant create job to loc_emos_common;
grant create materialized view to loc_emos_common;
grant create procedure to loc_emos_common;
grant create public synonym to loc_emos_common;
grant create sequence to loc_emos_common;
grant create session to loc_emos_common;
grant create table to loc_emos_common;
grant create trigger to loc_emos_common;
grant create type to loc_emos_common;
grant create view to loc_emos_common;
grant unlimited tablespace to loc_emos_common;
alter user loc_emos_common quota unlimited on loc_emos_common;
grant connect to loc_emos_sec;
grant create indextype to loc_emos_sec;
grant create job to loc_emos_sec;
grant create materialized view to loc_emos_sec;
grant create procedure to loc_emos_sec;
grant create public synonym to loc_emos_sec;
grant create sequence to loc_emos_sec;
grant create session to loc_emos_sec;
grant create table to loc_emos_sec;
grant create trigger to loc_emos_sec;
grant create type to loc_emos_sec;
grant create view to loc_emos_sec;
grant unlimited tablespace to loc_emos_sec;
alter user loc_emos_sec quota unlimited on loc_emos_sec;