create tablespace Service1_FPG_DATA datafile '+DATA' size 2G;
create tablespace APP1_MDM_FPG_DEMAND_ALLOC_DATA datafile '+DATA' size 2G;
create tablespace APP1_MDM_FPG_FACT_DATA datafile '+DATA' size 2G;
-- Service1DATA_FPG
CREATE USER Service1DATA_FPG
IDENTIFIED BY "<password>"
DEFAULT TABLESPACE Service1_FPG_DATA
TEMPORARY TABLESPACE TEMP
PROFILE APP_PROF
ACCOUNT UNLOCK;
ALTER USER Service1DATA_FPG DEFAULT ROLE ALL;
GRANT CONNECT, CREATE SESSION TO Service1DATA_FPG;
GRANT Service1DATA_READ to Service1DATA_FPG;
--- ACL
select * from dba_users where username ='Service1DATA_FPG';
SELECT * FROM dba_network_acl_privileges where principal='Service1DATA_FPG';
select * from dba_network_acls
select * from dba_network_acl_privileges
BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => '/sys/acls/system_email_perms.xml',
principal => 'Service1DATA_FPG',
is_grant => TRUE,
privilege => 'connect',
position => NULL,
start_date => NULL,
end_date => NULL);
COMMIT;
END;
Tablespace permission
ALTER USER Service1DATA_FPG QUOTA UNLIMITED ON Service1_FPG_DATA;
ALTER USER APP1_MDM_FPG_DEMAND_ALLOC QUOTA UNLIMITED ON APP1_MDM_FPG_DEMAND_ALLOC_DATA;
ALTER USER APP1_MDM_FPG_FACTORY QUOTA UNLIMITED ON APP1_MDM_FPG_FACT_DATA;