Oracle本地建三个用户

快来打我* 2022-03-22 07:44 134阅读 0赞

--建三个用户
    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;