GESTION DE USUARIOS -BD ORACLE

-- crear un usuario, ejemplo:

CREATE USER jamaya IDENTIFIED BY password
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;
  -- 4 Roles for jamaya
  GRANT EXP_FULL_DATABASE TO jamaya;
  GRANT RESOURCE TO jamaya;
  GRANT CONNECT TO jamaya;
  GRANT DBA TO jamaya;
  ALTER USER jamaya DEFAULT ROLE ALL;
  -- 1 System Privilege for jamaya
  GRANT UNLIMITED TABLESPACE TO jamaya;
  -- 1 Object Privilege for jamaya
    GRANT READ, WRITE ON DIRECTORY SYS.EXPORT TO jamaya WITH GRANT OPTION;

--Cambiar session de usuario desde SYS

ALTER SESSION SET CURRENT_SCHEMA = NOMBRESCHEMA;