oracle create user

drop user gsuser cascde;
drop user gsreaduser cascde;
drop user gsappuser cascde; 
drop role gs_read_role cascde;
drop role gs_app_role cascde;
CREATE USER gsuser IDENTIFIED BY gsuserpwd DEFAULT TABLESPACE GS_342_INIT_TBS TEMPORARY TABLESPACE GS_342_INIT_TBS_TMP profile DEFAULT quota unlimited on GS_342_INIT_TBS;
grant select on SYS.DBA_CONSTRAINTS to gsuser;
grant select on SYS.DBA_CONS_COLUMNS to gsuser;
grant select on SYS.DBA_DATA_FILES to gsuser;
grant select on SYS.DBA_OBJECTS to gsuser;
grant select on SYS.DBA_ERRORS to gsuser;
grant select on SYS.DBA_SOURCE to gsuser;
GRANT SELECT ON SYS.DBA_SEQUENCES to gsuser;  
grant select on SYS.DBA_SYNONYMS to gsuser;
grant select on SYS.DBA_TABLESPACES to gsuser;
grant select on SYS.DBA_TAB_COLUMNS to gsuser;
grant select on SYS.DBA_TAB_PRIVS to gsuser;
grant execute on SYS.DBMS_FLASHBACK to gsuser;
grant select on SYS.V_$MYSTAT to gsuser;
grant select on SYS.V_$PROCESS to gsuser;
grant select on SYS.V_$SESSION to gsuser;
grant select on sys.pending_trans$ to gsuser;
grant select on sys.dba_2pc_pending to gsuser;
grant select on sys.dba_pending_transactions to gsuser;
grant execute on sys.dbms_system to gsuser;
grant execute on sys.dbms_lock to gsuser;
grant execute on sys.dbms_lob to gsuser;
grant connect to gsuser;
grant javadebugpriv to gsuser;
grant javasyspriv to gsuser;
grant java_admin to gsuser;
grant alter session to gsuser;
grant create any synonym to gsuser;
grant drop any synonym to gsuser;
grant create cluster to gsuser;
grant create database link to gsuser;
grant create materialized view to gsuser;
grant create procedure to gsuser;
grant create sequence to gsuser;
grant create session to gsuser;
grant create table to gsuser;
grant create trigger to gsuser;
grant create type to gsuser;
grant create view to gsuser;
grant debug connect session to gsuser;
grant execute any procedure to gsuser;
CREATE USER gsreaduser IDENTIFIED BY gsreaduserpwd DEFAULT TABLESPACE GS_342_INIT_TBS TEMPORARY TABLESPACE GS_342_INIT_TBS_TMP profile DEFAULT;
create role gs_read_role;
grant alter session to gs_read_role;
grant create session to gs_read_role;
grant gs_read_role to gsreaduser;
CREATE USER gsappuser IDENTIFIED BY gsappuserpwd DEFAULT TABLESPACE GS_342_INIT_TBS TEMPORARY TABLESPACE GS_342_INIT_TBS_TMP profile DEFAULT;
create role gs_app_role;
grant gs_read_role to gs_app_role;
grant gs_app_role to gsappuser;
grant DBA to gsuser with admin option;