CODE EXAMPLE FOR SQL

crear usuario oracle

DROP USER miusuario CASCADE;

CREATE USER miusuario IDENTIFIED BY miclavesecreta
       DEFAULT TABLESPACE data  
       TEMPORARY TABLESPACE temp
       QUOTA UNLIMITED ON data;

CREATE ROLE programador;

GRANT CREATE session, CREATE table, CREATE view, 
      CREATE procedure,CREATE synonym,
      ALTER table, ALTER view, ALTER procedure,ALTER synonym,
      DROP table, DROP view, DROP procedure,DROP synonym,
      TO conn;

GRANT programador TO miusuario;