To Take the User Syntax..............

Create user systax
==========================================
select 'create user ' || '&usr' ||
       ' identified by ' || '&password' ||
       ' default tablespace ' || du.default_tablespace ||
       ' temporary tablespace ' || du.temporary_tablespace ||
       ' account unlock profile ' || du.profile
from dba_users du
where du.username = upper('&&usr') ;

quota for a user
==========================
select 'quota ' || decode(dtq.max_bytes,-1,'UNLIMITED',dtq.max_bytes) ||
       ' on ' || dtq.tablespace_name
from   dba_ts_quotas dtq
where  dtq.username = upper('&&usr') ;

/* GRANT NON-DEFAULT ROLES */
select 'grant ' || drp.granted_role || ' to ' || drp.grantee ||
       decode(drp.admin_option,'YES', ' with admin option ;', 'NO', ' ;')
from  dba_role_privs drp
where drp.grantee = upper('&&usr')
and   drp.default_role = 'NO' ;
/* GRANT DEFAULT ROLES */
select 'alter user ' || drp.grantee || ' default role ' || granted_role || ' ;'
from dba_role_privs drp
where drp.grantee = upper('&&usr')
and   drp.default_role = 'YES' ;
/* GRANT SYSTEM PRIVS */
SELECT 'grant ' || dsp.privilege || ' to ' || dsp.grantee ||
       decode(dsp.admin_option,'YES',' with admin option ;','NO',' ;')
from dba_sys_privs dsp
where dsp.grantee = upper('&&usr') ;
/* GRANT OBJECT PRIVS (NEED TO ADD CONNECT STATEMENTS) */
SELECT 'grant ' || dtp.privilege || ' on ' ||
       dtp.owner || '.' || dtp.table_name ||
       ' to ' || dtp.grantee ||
       decode(dtp.grantable, 'YES',' with grant option ;','NO',' ;')
from dba_tab_privs dtp
where dtp.grantee = upper('&&usr') ;