–表空间
CREATE TABLESPACE EBAPP_001 DATAFILE ‘EBAPP_001.DBF’ SIZE 20480 AUTOEXTEND ON NEXT 2048 WITH HUGE PATH ‘EBAPP_001’ STORAGE (ON RAFT_BP6);
CREATE TABLESPACE EBAPP_002 DATAFILE ‘EBAPP_002.DBF’ SIZE 20480 AUTOEXTEND ON NEXT 2048 WITH HUGE PATH ‘EBAPP_002’ STORAGE (ON RAFT_BP6);
–新建表空间组
SP_TS_GROUP_CREATE(‘EBAPP_TSG’, ‘tablespace group_ebapp’);
SP_TS_GROUP_ADD_TS(‘EBAPP_TSG’,‘EBAPP_001’);
SP_TS_GROUP_ADD_TS(‘EBAPP_TSG’,‘EBAPP_002’);

–新建用户指定使用那个表空间组
create user EHR_APP IDENTIFIED BY “SJZWJW@123” default tablespace GROUP “EBAPP_TSG”;
create user BIAPP IDENTIFIED BY “SJZWJW@123” default tablespace GROUP “EBAPP_TSG”;
–授权
grant “RESOURCE”,“SOI”,“SVI”,“VTI” to “EHR_APP”;
grant “RESOURCE”,“SOI”,“SVI”,“VTI” to BIAPP;