unix 2017-11-08 13-35-23

CREATE USER "EXT_MPI" IDENTIFIED BY "pass" DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;

GRANT "CONNECT" TO "EXT_MPI";


select
'GRANT SELECT, INSERT, DELETE ON '||owner||'.'||OBJECT_NAME||' to EXT_MPI;' query1_,
'CREATE OR REPLACE SYNONYM EXT_MPI.'||object_name||' FOR '||OWNER||'.'||OBJECT_NAME||';' query2
from SYS.ALL_OBJECTS where owner='INT_SVISTA' and OBJECT_TYPE='TABLE';

select
'GRANT SELECT ON '||owner||'.'||OBJECT_NAME||' to EXT_MPI;' query1,
'CREATE OR REPLACE SYNONYM EXT_MPI.'||object_name||' FOR '||OWNER||'.'||OBJECT_NAME||';' query2
from SYS.ALL_OBJECTS where owner='INT_SVISTA' and OBJECT_TYPE='SEQUENCE';

select
'GRANT EXECUTE ON '||owner||'.'||OBJECT_NAME||' to EXT_MPI;' query1,
'CREATE OR REPLACE SYNONYM EXT_MPI.'||object_name||' FOR '||OWNER||'.'||OBJECT_NAME||';' query2
from SYS.ALL_OBJECTS where owner='INT_SVISTA' and OBJECT_TYPE IN ('PROCEDURE', 'FUNCTION','PACKAGE');