sqlString="CREATE USER $1 IDENTIFIED BY $3
           DEFAULT TABLESPACE TEMPTABS
           TEMPORARY TABLESPACE TEMPSEGS
           QUOTA UNLIMITED ON TEMPTABS
           PROFILE DEFAULT
           ACCOUNT UNLOCK;

           GRANT xxxxxx_ROLE TO $1;
           ALTER USER $1 DEFAULT ROLE xxxxxx_ROLE;

           CREATE USER $2 IDENTIFIED EXTERNALLY
           DEFAULT TABLESPACE TEMPTABS
           TEMPORARY TABLESPACE TEMPSEGS
           QUOTA UNLIMITED ON TEMPTABS
           PROFILE DEFAULT
           ACCOUNT UNLOCK;

           GRANT xxxxxx_ROLE TO $2;
           GRANT yyyyyy_ROLE TO $2;
           ALTER USER $2 DEFAULT ROLE xxxxxx_ROLE,yyyyyy_ROLE;
           
           exit;"

           echo "$sqlString" > $APP_HOME/test/EMPMC.$$

sqlplus system/xxxxx @$APP_HOME/test/EMPMC.$$

rm $APP_HOME/test/EMPMC.$$