--Tablespace Creation CREATE BIGFILE TABLESPACE ACCOUNTS_TB DATAFILE '/oradata/datafiles/accounts_tb01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 512M MAXSIZE 34359738344K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE BIGFILE TABLESPACE JUTE_TB DATAFILE '/oradata/datafiles/jute_tb01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 512M MAXSIZE 34359738344K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE BIGFILE TABLESPACE MIS_TB DATAFILE '/oradata/datafiles/mis_tb01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 512M MAXSIZE 34359738344K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE BIGFILE TABLESPACE MNTNCE_TB DATAFILE '/oradata/datafiles/mntnce_tb01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 512M MAXSIZE 34359738344K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE BIGFILE TABLESPACE MREL_TB DATAFILE '/oradata/datafiles/mrel_tb01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 512M MAXSIZE 34359738344K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE BIGFILE TABLESPACE MRELHR_TB DATAFILE '/oradata/datafiles/mrelhr_tb01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 512M MAXSIZE 34359738344K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE BIGFILE TABLESPACE POWER_TB DATAFILE '/oradata/datafiles/power_tb01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 512M MAXSIZE 34359738344K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE BIGFILE TABLESPACE PRODUCTION_TB DATAFILE '/oradata/datafiles/production_tb01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 512M MAXSIZE 34359738344K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE BIGFILE TABLESPACE SALES_TB DATAFILE '/oradata/datafiles/sales_tb01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 512M MAXSIZE 34359738344K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE BIGFILE TABLESPACE SQC_TB DATAFILE '/oradata/datafiles/sqc_tb01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 512M MAXSIZE 34359738344K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE BIGFILE TABLESPACE STORES_TB DATAFILE '/oradata/datafiles/stores_tb01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 512M MAXSIZE 34359738344K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE BIGFILE TABLESPACE TMPDATA_TB DATAFILE '/oradata/datafiles/tmpdata_tb01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 512M MAXSIZE 34359738344K LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; /********************************************************************************************/ --Temporary Tablespace creation CREATE TEMPORARY TABLESPACE ACCOUNTS_TEMP TEMPFILE '/oradata/tempfiles/accounts_temp01.dbf' SIZE 1048M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M; CREATE TEMPORARY TABLESPACE JUTE_TEMP TEMPFILE '/oradata/tempfiles/jute_temp01.dbf' SIZE 1048M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M; CREATE TEMPORARY TABLESPACE MIS_TEMP TEMPFILE '/oradata/tempfiles/mis_temp01.dbf' SIZE 1048M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M; CREATE TEMPORARY TABLESPACE MNTNCE_TEMP TEMPFILE '/oradata/tempfiles/mntnce_temp01.dbf' SIZE 1048M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M; CREATE TEMPORARY TABLESPACE MREL_TEMP TEMPFILE '/oradata/tempfiles/mrel_temp01.dbf' SIZE 21848M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M; CREATE TEMPORARY TABLESPACE MRELHR_TEMP TEMPFILE '/oradata/tempfiles/mrelhr_temp01.dbf' SIZE 1048M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M; CREATE TEMPORARY TABLESPACE POWER_TEMP TEMPFILE '/oradata/tempfiles/power_temp01.dbf' SIZE 1048M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M; CREATE TEMPORARY TABLESPACE PRODUCTION_TEMP TEMPFILE '/oradata/tempfiles/production_temp01.dbf' SIZE 1048M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M; CREATE TEMPORARY TABLESPACE SALES_TEMP TEMPFILE '/oradata/tempfiles/sales_temp01.dbf' SIZE 1048M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M; CREATE TEMPORARY TABLESPACE SQC_TEMP TEMPFILE '/oradata/tempfiles/sqc_temp01.dbf' SIZE 1048M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M; CREATE TEMPORARY TABLESPACE STORES_TEMP TEMPFILE '/oradata/tempfiles/stores_temp01.dbf' SIZE 9888M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M; CREATE TEMPORARY TABLESPACE TMPDATA_TEMP TEMPFILE '/oradata/tempfiles/tmpdata_temp01.dbf' SIZE 1048M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M; /********************************************************************************************************************/ --User Creation DROP USER ACCOUNTS CASCADE; CREATE USER ACCOUNTS IDENTIFIED BY VALUES ACCOUNTS DEFAULT TABLESPACE ACCOUNTS_TB TEMPORARY TABLESPACE ACCOUNTS_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for ACCOUNTS GRANT CONNECT TO ACCOUNTS; GRANT DBA TO ACCOUNTS; GRANT RESOURCE TO ACCOUNTS; ALTER USER ACCOUNTS DEFAULT ROLE ALL; -- 1 System Privilege for ACCOUNTS GRANT UNLIMITED TABLESPACE TO ACCOUNTS; -- 1 Object Privilege for ACCOUNTS GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON SALES.SALES_CONSIG_OPENING_BALANCE TO ACCOUNTS; DROP USER JUTEOFFICE CASCADE; CREATE USER JUTEOFFICE IDENTIFIED BY VALUES JUTE5954 DEFAULT TABLESPACE JUTE_TB TEMPORARY TABLESPACE JUTE_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for JUTEOFFICE GRANT CONNECT TO JUTEOFFICE; GRANT RESOURCE TO JUTEOFFICE; GRANT DBA TO JUTEOFFICE; ALTER USER JUTEOFFICE DEFAULT ROLE ALL; -- 5 System Privileges for JUTEOFFICE GRANT UNLIMITED TABLESPACE TO JUTEOFFICE; GRANT CREATE MATERIALIZED VIEW TO JUTEOFFICE; GRANT CREATE ANY MATERIALIZED VIEW TO JUTEOFFICE; GRANT GLOBAL QUERY REWRITE TO JUTEOFFICE; GRANT CREATE SESSION TO JUTEOFFICE; -- 2 Object Privileges for JUTEOFFICE GRANT DELETE, INSERT, SELECT, UPDATE ON MREL.MREL_RAW_JUTE_PRICE_COMB_MAST TO JUTEOFFICE; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON MRELHR.HR_ATTND_DTLS TO JUTEOFFICE; -- 1 Java Privilege for JUTEOFFICE DECLARE KEYNUM NUMBER; BEGIN SYS.DBMS_JAVA.GRANT_PERMISSION( grantee => 'JUTEOFFICE' ,permission_type => 'SYS:java.io.FilePermission' ,permission_name => '/oradata/att' ,permission_action => 'read' ,key => KEYNUM ); END; / CREATE USER MAINTENANCE IDENTIFIED BY VALUES MAINTENANCE DEFAULT TABLESPACE MNTNCE_TB TEMPORARY TABLESPACE MNTNCE_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for MAINTENANCE GRANT DBA TO MAINTENANCE; GRANT CONNECT TO MAINTENANCE; GRANT RESOURCE TO MAINTENANCE; ALTER USER MAINTENANCE DEFAULT ROLE ALL; -- 1 System Privilege for MAINTENANCE GRANT UNLIMITED TABLESPACE TO MAINTENANCE; DROP USER MIS CASCADE; CREATE USER MIS IDENTIFIED BY VALUES MIS DEFAULT TABLESPACE MIS_TB TEMPORARY TABLESPACE MIS_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for MIS GRANT RESOURCE TO MIS; GRANT CONNECT TO MIS; GRANT DBA TO MIS; ALTER USER MIS DEFAULT ROLE ALL; -- 1 System Privilege for MIS GRANT UNLIMITED TABLESPACE TO MIS; DROP USER MREL CASCADE; CREATE USER MREL IDENTIFIED BY VALUES MREL DEFAULT TABLESPACE MREL_TB TEMPORARY TABLESPACE MREL_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for MREL GRANT CONNECT TO MREL; GRANT RESOURCE TO MREL; GRANT DBA TO MREL; ALTER USER MREL DEFAULT ROLE ALL; -- 1 System Privilege for MREL GRANT UNLIMITED TABLESPACE TO MREL; -- 66 Object Privileges for MREL GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON ACCOUNTS.ACCOUNTS_PARTY_GL_DTLS TO MREL; GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON ACCOUNTS.ACCOUNTS_VOUCHER_DTLS TO MREL; GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON ACCOUNTS.ACCOUNTS_VOUCHER_MAST TO MREL; GRANT EXECUTE, DEBUG ON JUTEOFFICE.COMMA_TO_TABLE TO MREL; GRANT EXECUTE ON JUTEOFFICE.DAILYMR_ARV TO MREL; GRANT EXECUTE, DEBUG ON JUTEOFFICE.DAILY_OPBAL TO MREL; GRANT EXECUTE, DEBUG ON JUTEOFFICE.DELETE_CLOSINGVAL1 TO MREL; GRANT EXECUTE, DEBUG ON JUTEOFFICE.DIR_LIST TO MREL; GRANT EXECUTE ON JUTEOFFICE.FIN_YR TO MREL; GRANT EXECUTE ON JUTEOFFICE.FUNC_RETN_MUKAMS TO MREL; GRANT EXECUTE, DEBUG ON JUTEOFFICE.INSERT_CLOSINGVAL1 TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON JUTEOFFICE.JUTEOFFICE_AGMT_DTLS TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON JUTEOFFICE.JUTEOFFICE_AGMT_MAST TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON JUTEOFFICE.JUTEOFFICE_INV_MAST TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON JUTEOFFICE.JUTEOFFICE_MR_CLAIM TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON JUTEOFFICE.JUTEOFFICE_MR_DTLS TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON JUTEOFFICE.JUTEOFFICE_MR_MAST TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON JUTEOFFICE.JUTEOFFICE_NEWCROP_BASIS TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON JUTEOFFICE.JUTEOFFICE_PARTY_BILL_DTLS TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON JUTEOFFICE.JUTEOFFICE_PARTY_BILL_MAST TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON JUTEOFFICE.JUTEOFFICE_PAYMENT_DTLS TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON JUTEOFFICE.JUTEOFFICE_PAYMENT_MAST TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON JUTEOFFICE.JUTEOFFICE_SCHEDULE_MAST TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON JUTEOFFICE.JUTEOFFICE_TERMCOND_MAST TO MREL; GRANT EXECUTE, DEBUG ON JUTEOFFICE.RAW_DIR_LIST TO MREL; GRANT EXECUTE, DEBUG ON JUTEOFFICE.READATT TO MREL; GRANT EXECUTE, DEBUG ON JUTEOFFICE.RUNREADATT TO MREL; GRANT EXECUTE ON JUTEOFFICE.TRANSFER_PO TO MREL; GRANT EXECUTE, DEBUG ON JUTEOFFICE.UPDATE_DAILY_OPBAL TO MREL; GRANT SELECT ON JUTEOFFICE.VU_DISTINCT_WAYBILLNO TO MREL; GRANT SELECT ON JUTEOFFICE.VU_JUTEWISE_REQ_ISSUE TO MREL; GRANT SELECT ON JUTEOFFICE.VU_PO_CHLN_MR TO MREL WITH GRANT OPTION; GRANT SELECT ON JUTEOFFICE.VU_SCHEDULE_JUTE_TOT TO MREL; GRANT SELECT ON JUTEOFFICE.VU_SUM_PO_CHLN_MR TO MREL WITH GRANT OPTION; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON MAINTENANCE.MTN_JOBLIST TO MREL; GRANT EXECUTE, DEBUG ON MRELHR.PROC_TMP_ATTND_POP TO MREL; GRANT EXECUTE, DEBUG ON POWER.EMP_ARY TO MREL; GRANT EXECUTE, DEBUG ON POWER.EMP_TYP TO MREL; GRANT EXECUTE, DEBUG ON POWER.PK_POWER TO MREL; GRANT DELETE, INSERT, SELECT, UPDATE ON RWIZARD.TEMP_JUTE_GODOWN_STOCK TO MREL; GRANT SELECT ON SALES."BIN$gyh0C6+fTVngQKjA+AoN8g==$0" TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.PUR_CONT_DELIVERY_SCHEDULE TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON SALES.SALES_CONSIG_OPENING_BALANCE TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_JOB_MASTER TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON SALES.SALES_PAY_RCV_DTLS TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON SALES.SALES_PAY_RCV_MAST TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_PUR_CONT_MASTER TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_PUR_CONT_PACK_COMP TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_PUR_CONT_QLTY_COMPONENTS TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_PUR_CONT_QUALITY TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_QLTY_PACKING_COMPONENTS TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_QLTY_PACKING_MASTER TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_SALEADV_MASTER TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_SALEADV_PACK_COMP TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_SALEADV_QLTY_COMPONENTS TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_SALE_ADVICE_MASTER TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_SALE_ADVICE_PACK_COMP TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_SALE_ADVICE_QUALITY TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_SALE_ADV_QLTY_COMPONENTS TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON SALES.SALES_SALE_TYPE_MASTER TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON STORES.STORES_ITEM_WISE_INPUT_CREDIT TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON STORES.STORES_OTHER_BILL_CHARGES TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON STORES.STORES_OTHER_BILL_DTLS TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON STORES.STORES_OTHER_BILL_MAST TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON TMPDATA.SALEMAST TO MREL; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON TMPDATA.SALEMAST1 TO MREL; -- 1 Java Privilege for MREL DECLARE KEYNUM NUMBER; BEGIN SYS.DBMS_JAVA.GRANT_PERMISSION( grantee => 'MREL' ,permission_type => 'SYS:java.net.SocketPermission' ,permission_name => '192.168.10.248:7778' ,permission_action => 'connect,resolve' ,key => KEYNUM ); END; / DROP USER MRELHR CASCADE; CREATE USER MRELHR IDENTIFIED BY VALUES MRELHR DEFAULT TABLESPACE MRELHR_TB TEMPORARY TABLESPACE MRELHR_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for MRELHR GRANT CONNECT TO MRELHR; GRANT RESOURCE TO MRELHR; GRANT DBA TO MRELHR; ALTER USER MRELHR DEFAULT ROLE ALL; -- 1 System Privilege for MRELHR GRANT UNLIMITED TABLESPACE TO MRELHR; DROP USER POWER CASCADE; CREATE USER POWER IDENTIFIED BY VALUES POWER DEFAULT TABLESPACE POWER_TB TEMPORARY TABLESPACE POWER_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for POWER GRANT DBA TO POWER; GRANT CONNECT TO POWER; GRANT RESOURCE TO POWER; ALTER USER POWER DEFAULT ROLE ALL; -- 1 System Privilege for POWER GRANT UNLIMITED TABLESPACE TO POWER; -- 3 Object Privileges for POWER GRANT SELECT ON MAINTENANCE.MTN_MC_MAST TO POWER; GRANT SELECT ON MAINTENANCE.MTN_MC_PARAM_MAST TO POWER; GRANT SELECT ON MAINTENANCE.MTN_MC_TYPE_MAST TO POWER; DROP USER PRODUCTION CASCADE; CREATE USER PRODUCTION IDENTIFIED BY VALUES PRODUCTION DEFAULT TABLESPACE PRODUCTION_TB TEMPORARY TABLESPACE PRODUCTION_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for PRODUCTION GRANT DBA TO PRODUCTION; GRANT RESOURCE TO PRODUCTION; GRANT CONNECT TO PRODUCTION; ALTER USER PRODUCTION DEFAULT ROLE ALL; -- 1 System Privilege for PRODUCTION GRANT UNLIMITED TABLESPACE TO PRODUCTION; DROP USER RWIZARD CASCADE; CREATE USER RWIZARD IDENTIFIED BY VALUES RWIZARD DEFAULT TABLESPACE SQC_TB TEMPORARY TABLESPACE SQC_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 1 Role for RWIZARD GRANT DBA TO RWIZARD; ALTER USER RWIZARD DEFAULT ROLE ALL; -- 1 System Privilege for RWIZARD GRANT UNLIMITED TABLESPACE TO RWIZARD; DROP USER SALES CASCADE; CREATE USER SALES IDENTIFIED BY VALUES SALES DEFAULT TABLESPACE SALES_TB TEMPORARY TABLESPACE SALES_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for SALES GRANT CONNECT TO SALES; GRANT DBA TO SALES; GRANT RESOURCE TO SALES; ALTER USER SALES DEFAULT ROLE ALL; -- 123 System Privileges for SALES GRANT ALTER ANY OUTLINE TO SALES; GRANT CREATE ANY INDEXTYPE TO SALES; GRANT CREATE INDEXTYPE TO SALES; GRANT ALTER ANY OPERATOR TO SALES; GRANT DROP ANY TYPE TO SALES; GRANT ALTER ANY TYPE TO SALES; GRANT DROP ANY DIRECTORY TO SALES; GRANT DROP ANY TRIGGER TO SALES; GRANT ALTER ANY TRIGGER TO SALES; GRANT DROP ANY PROCEDURE TO SALES; GRANT ALTER ANY ROLE TO SALES; GRANT GRANT ANY ROLE TO SALES; GRANT SELECT ANY SEQUENCE TO SALES; GRANT DROP ANY SEQUENCE TO SALES; GRANT CREATE VIEW TO SALES; GRANT ALTER ANY INDEX TO SALES; GRANT CREATE CLUSTER TO SALES; GRANT UPDATE ANY TABLE TO SALES; GRANT COMMENT ANY TABLE TO SALES; GRANT CREATE ANY TABLE TO SALES; GRANT CREATE TABLE TO SALES; GRANT DROP TABLESPACE TO SALES; GRANT MANAGE TABLESPACE TO SALES; GRANT ALTER SESSION TO SALES; GRANT ALTER ANY DIMENSION TO SALES; GRANT CREATE DIMENSION TO SALES; GRANT GLOBAL QUERY REWRITE TO SALES; GRANT CREATE ANY OPERATOR TO SALES; GRANT DROP ANY MATERIALIZED VIEW TO SALES; GRANT CREATE TRIGGER TO SALES; GRANT ALTER ANY PROCEDURE TO SALES; GRANT FORCE ANY TRANSACTION TO SALES; GRANT CREATE ROLE TO SALES; GRANT CREATE DATABASE LINK TO SALES; GRANT CREATE ANY SEQUENCE TO SALES; GRANT DROP ANY VIEW TO SALES; GRANT CREATE PUBLIC SYNONYM TO SALES; GRANT DROP ANY SYNONYM TO SALES; GRANT DROP ANY TABLE TO SALES; GRANT ALTER ANY TABLE TO SALES; GRANT DROP ROLLBACK SEGMENT TO SALES; GRANT ALTER ROLLBACK SEGMENT TO SALES; GRANT ALTER TABLESPACE TO SALES; GRANT RESTRICTED SESSION TO SALES; GRANT ALTER ANY INDEXTYPE TO SALES; GRANT DROP ANY LIBRARY TO SALES; GRANT CREATE ANY LIBRARY TO SALES; GRANT CREATE ANY MATERIALIZED VIEW TO SALES; GRANT ALTER PROFILE TO SALES; GRANT FORCE TRANSACTION TO SALES; GRANT ALTER DATABASE TO SALES; GRANT DROP PUBLIC DATABASE LINK TO SALES; GRANT CREATE SYNONYM TO SALES; GRANT DROP ANY CLUSTER TO SALES; GRANT CREATE ANY CONTEXT TO SALES; GRANT DROP ANY DIMENSION TO SALES; GRANT DROP ANY INDEXTYPE TO SALES; GRANT CREATE ANY TYPE TO SALES; GRANT GRANT ANY PRIVILEGE TO SALES; GRANT CREATE ANY TRIGGER TO SALES; GRANT EXECUTE ANY PROCEDURE TO SALES; GRANT ALTER ANY SEQUENCE TO SALES; GRANT CREATE SEQUENCE TO SALES; GRANT CREATE ANY SYNONYM TO SALES; GRANT BACKUP ANY TABLE TO SALES; GRANT BECOME USER TO SALES; GRANT UNLIMITED TABLESPACE TO SALES; GRANT UNDER ANY TABLE TO SALES; GRANT DROP ANY OPERATOR TO SALES; GRANT ALTER ANY MATERIALIZED VIEW TO SALES; GRANT CREATE MATERIALIZED VIEW TO SALES; GRANT ALTER RESOURCE COST TO SALES; GRANT DROP ANY ROLE TO SALES; GRANT CREATE ANY INDEX TO SALES; GRANT CREATE ANY CLUSTER TO SALES; GRANT SELECT ANY TABLE TO SALES; GRANT CREATE USER TO SALES; GRANT DEBUG ANY PROCEDURE TO SALES; GRANT DEBUG CONNECT SESSION TO SALES; GRANT SELECT ANY DICTIONARY TO SALES; GRANT DROP ANY OUTLINE TO SALES; GRANT DROP ANY CONTEXT TO SALES; GRANT CREATE OPERATOR TO SALES; GRANT ALTER ANY LIBRARY TO SALES; GRANT CREATE TYPE TO SALES; GRANT ANALYZE ANY TO SALES; GRANT CREATE ANY PROCEDURE TO SALES; GRANT CREATE PUBLIC DATABASE LINK TO SALES; GRANT DROP PUBLIC SYNONYM TO SALES; GRANT DROP ANY INDEX TO SALES; GRANT CREATE ROLLBACK SEGMENT TO SALES; GRANT ALTER SYSTEM TO SALES; GRANT FLASHBACK ANY TABLE TO SALES; GRANT ON COMMIT REFRESH TO SALES; GRANT ADMINISTER DATABASE TRIGGER TO SALES; GRANT CREATE ANY DIMENSION TO SALES; GRANT EXECUTE ANY INDEXTYPE TO SALES; GRANT QUERY REWRITE TO SALES; GRANT UNDER ANY VIEW TO SALES; GRANT EXECUTE ANY LIBRARY TO SALES; GRANT EXECUTE ANY TYPE TO SALES; GRANT CREATE ANY DIRECTORY TO SALES; GRANT CREATE PROFILE TO SALES; GRANT AUDIT ANY TO SALES; GRANT CREATE ANY VIEW TO SALES; GRANT DELETE ANY TABLE TO SALES; GRANT CREATE TABLESPACE TO SALES; GRANT GRANT ANY OBJECT PRIVILEGE TO SALES; GRANT RESUMABLE TO SALES; GRANT EXEMPT ACCESS POLICY TO SALES; GRANT CREATE ANY OUTLINE TO SALES; GRANT EXECUTE ANY OPERATOR TO SALES; GRANT CREATE LIBRARY TO SALES; GRANT UNDER ANY TYPE TO SALES; GRANT DROP PROFILE TO SALES; GRANT CREATE PROCEDURE TO SALES; GRANT ALTER ANY CLUSTER TO SALES; GRANT INSERT ANY TABLE TO SALES; GRANT LOCK ANY TABLE TO SALES; GRANT DROP USER TO SALES; GRANT ALTER USER TO SALES; GRANT CREATE SESSION TO SALES; GRANT AUDIT SYSTEM TO SALES; -- 8 Object Privileges for SALES GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON ACCOUNT.ATB_FINYEAR TO SALES; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON ACCOUNT.ATB_SUPPLIER TO SALES; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON MREL."BIN$W44bqCwyA87gQKjA+ApfFA==$0" TO SALES; GRANT REFERENCES ON MREL.MREL_COMPANY_MAST TO SALES; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON MREL.MREL_PRODUCT_DETAILS TO SALES; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK ON MREL.MREL_PRODUCT_MASTER TO SALES; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON MREL.MREL_QUALITY_COMPONENTS TO SALES; GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG ON MREL.MREL_QUALITY_MAST TO SALES; DROP USER SQC CASCADE; CREATE USER SQC IDENTIFIED BY VALUES SQC DEFAULT TABLESPACE SQC_TB TEMPORARY TABLESPACE SQC_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for SQC GRANT CONNECT TO SQC; GRANT RESOURCE TO SQC; GRANT DBA TO SQC; ALTER USER SQC DEFAULT ROLE ALL; -- 1 System Privilege for SQC GRANT UNLIMITED TABLESPACE TO SQC; DROP USER STORES CASCADE; CREATE USER STORES IDENTIFIED BY VALUES STORES DEFAULT TABLESPACE STORES_TB TEMPORARY TABLESPACE STORES_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for STORES GRANT RESOURCE TO STORES; GRANT DBA TO STORES; GRANT CONNECT TO STORES; ALTER USER STORES DEFAULT ROLE ALL; -- 1 System Privilege for STORES GRANT UNLIMITED TABLESPACE TO STORES; -- 1 Object Privilege for STORES GRANT SELECT ON SALES.EUL5_MV101093 TO STORES; DROP USER TMPDATA CASCADE; CREATE USER TMPDATA IDENTIFIED BY VALUES TMPDATA DEFAULT TABLESPACE TMPDATA_TB TEMPORARY TABLESPACE TMPDATA_TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for TMPDATA GRANT DBA TO TMPDATA; GRANT RESOURCE TO TMPDATA; GRANT CONNECT TO TMPDATA; ALTER USER TMPDATA DEFAULT ROLE ALL; -- 12 System Privileges for TMPDATA GRANT ANALYZE ANY TO TMPDATA; GRANT CREATE SESSION TO TMPDATA; GRANT UNLIMITED TABLESPACE TO TMPDATA; GRANT ALTER ANY MATERIALIZED VIEW TO TMPDATA; GRANT CREATE TABLE TO TMPDATA; GRANT CREATE VIEW TO TMPDATA; GRANT CREATE ANY MATERIALIZED VIEW TO TMPDATA; GRANT CREATE PROCEDURE TO TMPDATA; GRANT CREATE SEQUENCE TO TMPDATA; GRANT DROP ANY MATERIALIZED VIEW TO TMPDATA; GRANT GLOBAL QUERY REWRITE TO TMPDATA; GRANT CREATE ROLE TO TMPDATA;