oracle create role and user

ora-create-role.sql

create role programador;
GRANT CONNECT TO programador;
GRANT create session, alter session TO programador;
GRANT create procedure to programador;
GRANT execute any procedure to programador;
GRANT create table TO programador;
GRANT create sequence TO programador;
Grant create trigger to programador;
Grant create type to programador;
grant create view to programador;
grant create any index, create indextype to programador;
grant debug connect session to programador;
grant debug any procedure to programador;


CREATE USER user-name IDENTIFIED BY ppppppp;
GRANT programador TO user-name;


ALTER DATABASE DEFAULT TABLESPACE USERS;
ALTER USER user-name QUOTA UNLIMITED ON USERS;