select 'create user '||cod_usuario||' identified by '||cod_usuario||' default tablespace datos ;'
from seg_usuario;
select 'grant connect,dba,resource to '||cod_usuario||' ; '  from seg_usuario;
select 'grant sistemas to '||cod_usuario||' ; '  from seg_usuario;



create user ARISTIDES identified by ARISTIDES default tablespace datos ;
create user CARLOS identified by CARLOS default tablespace datos ;
create user DGOMEZ identified by DGOMEZ default tablespace datos ;
create user FRANCISCO identified by FRANCISCO default tablespace datos ;
create user HHENRIQUEZ identified by HHENRIQUEZ default tablespace datos ;
create user VVASQUEZ identified by VVASQUEZ default tablespace datos ;



grant connect,dba,resource to ARISTIDES ;
grant connect,dba,resource to CARLOS ;
grant connect,dba,resource to DGOMEZ ;
grant connect,dba,resource to FRANCISCO ;
grant connect,dba,resource to HHENRIQUEZ ;
grant connect,dba,resource to LANCO ;
grant connect,dba,resource to LANCOPA ;
grant connect,dba,resource to VVASQUEZ ;



grant sistemas to ARISTIDES ;
grant sistemas to CARLOS ;
grant sistemas to DGOMEZ ;
grant sistemas to FRANCISCO ;
grant sistemas to HHENRIQUEZ ;
grant sistemas to LANCO ;
grant sistemas to LANCOPA ;
grant sistemas to VVASQUEZ ;