CREATE USER CDSL
  IDENTIFIED BY <password>
  DEFAULT TABLESPACE CDSL
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;
  -- 2 Roles for CDSL 
  GRANT DBA TO CDSL WITH ADMIN OPTION;
  GRANT ISSLAPPS TO CDSL WITH ADMIN OPTION;
  ALTER USER CDSL DEFAULT ROLE ALL;
  -- 10 System Privileges for CDSL 
  GRANT SELECT ANY TRANSACTION TO CDSL;
  GRANT DEBUG ANY PROCEDURE TO CDSL;
  GRANT QUERY REWRITE TO CDSL;
  GRANT CREATE DATABASE LINK TO CDSL;
  GRANT DEBUG CONNECT SESSION TO CDSL;
  GRANT CREATE MATERIALIZED VIEW TO CDSL;
  GRANT UNLIMITED TABLESPACE TO CDSL WITH ADMIN OPTION;
  GRANT CREATE JOB TO CDSL;
  GRANT EXECUTE ANY PROCEDURE TO CDSL;
  GRANT CREATE VIEW TO CDSL;
  -- 4 Tablespace Quotas for CDSL 
  ALTER USER CDSL QUOTA UNLIMITED ON USERS;
  ALTER USER CDSL QUOTA UNLIMITED ON CDSL;
  ALTER USER CDSL QUOTA UNLIMITED ON INDXUAT;
  ALTER USER CDSL QUOTA UNLIMITED ON CDSL_INDX;
  -- 42 Object Privileges for CDSL 
    GRANT EXECUTE ON  CAT.ORA_CHK_MNTH_STATUS TO CDSL;
    GRANT EXECUTE ON  CAT.ORA_GENERATE_TRAN_NUMBER_CDSL TO CDSL;
    GRANT INSERT, SELECT, UPDATE ON  CAT.TR_LAST_VCH TO CDSL;
    GRANT INSERT, SELECT ON  CAT.TR_VCH_DTL TO CDSL;
    GRANT INSERT, SELECT ON  CAT.TR_VCH_HDR TO CDSL;
    GRANT SELECT ON  CDSLWEB.SEQ_TRANSNUMBER TO CDSL;
    GRANT INSERT, SELECT, UPDATE ON  CDSLWEB.TBL_DEPOSITORYCLIENT TO CDSL;
    GRANT INSERT, SELECT, UPDATE ON  CDSLWEB.TBL_DEPOSITORYGROUP TO CDSL;
    GRANT SELECT, UPDATE ON  CDSLWEB.TBL_PLEDGETRANSACTION TO CDSL;
    GRANT INSERT, SELECT, UPDATE ON  CDSLWEB.TBL_POADETAILS TO CDSL;
    GRANT SELECT, UPDATE ON  CDSLWEB.TBL_TXNDTLS TO CDSL;
    GRANT SELECT, UPDATE ON  CDSLWEB.TBL_TXNMSTR TO CDSL;
    GRANT SELECT, UPDATE ON  CDSLWEB.TBL_TXNMSTR1 TO CDSL;
    GRANT SELECT, UPDATE ON  CDSLWEB.TBL_TXNSMMRY TO CDSL;
    GRANT SELECT, UPDATE ON  CDSLWEB.TBL_UPLOAD_DETAILS TO CDSL;
    GRANT SELECT ON  DP2BOSS.TBL_BPMASTER TO CDSL;
    GRANT SELECT ON  DP2BOSS.TBL_CCCALENDAR TO CDSL;
    GRANT SELECT ON  DP2BOSS.TBL_DAILYPRICELIST TO CDSL;
    GRANT SELECT ON  DP2BOSS.TBL_ISINMASTER TO CDSL;
    GRANT SELECT ON  DPBOSS.MV_UAPA_UPLOADDTL TO CDSL;
    GRANT SELECT ON  DPBOSS.TBL_BPMASTER TO CDSL;
    GRANT SELECT ON  DPBOSS.VW_KYC_CDSL TO CDSL;
    GRANT SELECT ON  SYS.DBA_REFRESH TO CDSL;
    GRANT EXECUTE ON  SYS.DBMS_IREFRESH TO CDSL;
    GRANT EXECUTE ON  SYS.DBMS_ISCHED TO CDSL WITH GRANT OPTION;
    GRANT EXECUTE ON  SYS.DBMS_LOB TO CDSL;
    GRANT EXECUTE ON  SYS.DBMS_OUTPUT TO CDSL;
    GRANT EXECUTE ON  SYS.DBMS_REFRESH TO CDSL;
    GRANT EXECUTE ON  SYS.DBMS_SCHEDULER TO CDSL WITH GRANT OPTION;
    GRANT EXECUTE ON  SYS.DBMS_SNAPSHOT TO CDSL;
    GRANT EXECUTE ON  SYS.DBMS_SYS_ERROR TO CDSL;
    GRANT EXECUTE ON  SYS.DBMS_XMLGEN TO CDSL;
    GRANT EXECUTE ON  SYS.DBMS_XMLQUERY TO CDSL;
    GRANT EXECUTE ON  SYS.DBMS_XMLSAVE TO CDSL;
    GRANT EXECUTE ON  SYS.DBMS_XMLSTORE TO CDSL;
    GRANT SELECT ON  SYS.SESSION_INFO TO CDSL;
    GRANT SELECT ON  SYS.SESSION_STAT TO CDSL;
    GRANT EXECUTE ON  SYS.UTL_FILE TO CDSL;
    GRANT EXECUTE ON  SYS.UTL_HTTP TO CDSL;
    GRANT EXECUTE ON  SYS.UTL_MAIL TO CDSL;
    GRANT EXECUTE ON  SYS.UTL_SMTP TO CDSL;
    GRANT EXECUTE ON  SYS.UTL_TCP TO CDSL;

impdp system/<password> SCHEMAS=CDSL DIRECTORY=EXPBKUP DUMPFILE=CDSL_Export.dmp LOGFILE=CDSL_imp.log  INCLUDE=TABLE TABLE_EXISTS_ACTION=REPLACE