/*
Following arguments passed to this sql file
"&1" is table space name
"&2" is data file name
"&3" is username
"&4" is password
*/
Create Tablespace &1 DATAFILE '&2' size 2048M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
CREATE USER &3 IDENTIFIED BY &4 DEFAULT TABLESPACE &1 QUOTA UNLIMITED ON &1 PROFILE DEFAULT;
GRANT CONNECT TO &3;
GRANT RESOURCE TO &3;
GRANT select on sys.dba_pending_transactions to &3;
GRANT select on pending_trans$ to public;
GRANT select on dba_2pc_pending to public;
GRANT select on dba_pending_transactions to public;
GRANT execute on dbms_system to &3;

/
QUIT;


