/*
Certifique-se que o diretorios: /dados/oracle/oradata
exista e que o usuario oracle tenha acesso a ele

*/
prompt Configurando ...
ALTER SYSTEM SET open_cursors=3000 SCOPE=spfile;
ALTER SYSTEM SET optimizer_mode=RULE SCOPE=spfile;
ALTER SYSTEM SET processes=150 SCOPE=spfile;
ALTER SYSTEM SET sessions=170 SCOPE=spfile;

prompt Criando Tablespace ...
CREATE SMALLFILE TABLESPACE ODIN
DATAFILE '/dados/oracle/oradata/odin01.dbf' SIZE 1G
AUTOEXTEND ON NEXT 10M MAXSIZE
UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT
SPACE MANAGEMENT AUTO;

prompt Alterando Users para 2MB ...
ALTER DATABASE DATAFILE '/usr/lib/oracle/xe/oradata/XE/users.dbf' RESIZE 2M;

prompt Criando Usuario Odin ...

create user ODIN
  identified by vtx4753
  default tablespace ODIN
  temporary tablespace TEMP
  profile DEFAULT;

grant connect to ODIN;
grant dba to ODIN;
grant resource to ODIN;
grant unlimited tablespace to ODIN;
GRANT ALTER ANY PROCEDURE TO ODIN;
GRANT ALTER ANY TRIGGER TO ODIN;
GRANT ANALYZE ANY TO ODIN;
GRANT CREATE ANY SEQUENCE TO ODIN;
GRANT CREATE ANY TABLE TO ODIN;
GRANT CREATE ANY VIEW TO ODIN;
GRANT CREATE SYNONYM TO ODIN;
GRANT CREATE TRIGGER TO ODIN;
GRANT DELETE ANY TABLE TO ODIN;
GRANT DROP ANY SEQUENCE TO ODIN;
GRANT DROP ANY TABLE TO ODIN;
GRANT EXECUTE ANY PROCEDURE TO ODIN;
GRANT INSERT ANY TABLE TO ODIN;
GRANT SELECT ANY DICTIONARY TO ODIN;
GRANT SELECT ANY SEQUENCE TO ODIN;
GRANT SELECT ANY TABLE TO ODIN;
GRANT UNLIMITED TABLESPACE TO ODIN;
GRANT UPDATE ANY TABLE TO ODIN;


ALTER PROFILE default LIMIT
   FAILED_LOGIN_ATTEMPTS 1000;

connect sys/vortex@xe as sysdba

GRANT EXECUTE ON UTL_FILE TO PUBLIC;
GRANT EXECUTE ON UTL_SMTP TO PUBLIC;
GRANT EXECUTE ON CTX_DDL TO PUBLIC;
GRANT EXECUTE ON DBMS_CRYPTO TO PUBLIC;
GRANT EXECUTE ON DBMS_LOCK TO PUBLIC;
GRANT EXECUTE ON DBMS_IJOB TO PUBLIC;
GRANT EXECUTE ON DBMS_NETWORK_ACL_ADMIN TO PUBLIC;


connect system/vortex@xe


exit