Skip to content

Instantly share code, notes, and snippets.

@igorsgm
Created August 13, 2018 16:53
Show Gist options
  • Save igorsgm/70e133275270f3e2c1ff95c1f96a625f to your computer and use it in GitHub Desktop.
Save igorsgm/70e133275270f3e2c1ff95c1f96a625f to your computer and use it in GitHub Desktop.
#Criar novo Usuário e Schema no Banco de Dados Oracle
CREATE USER NOME_USUARIO_AQUI IDENTIFIED BY SENHA_USUARIO_AQUI DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK;
GRANT CREATE SESSION TO NOME_USUARIO_AQUI;
GRANT CREATE TABLE TO NOME_USUARIO_AQUI;
ALTER USER NOME_USUARIO_AQUI QUOTA UNLIMITED ON USERS;
GRANT EXP_FULL_DATABASE TO NOME_USUARIO_AQUI;
GRANT CONNECT TO NOME_USUARIO_AQUI;
GRANT create session, alter session TO NOME_USUARIO_AQUI;
GRANT create procedure to NOME_USUARIO_AQUI;
GRANT execute any procedure to NOME_USUARIO_AQUI;
GRANT create table TO NOME_USUARIO_AQUI;
GRANT create sequence TO NOME_USUARIO_AQUI;
GRANT create trigger to NOME_USUARIO_AQUI;
GRANT create type to NOME_USUARIO_AQUI;
GRANT create view to NOME_USUARIO_AQUI;
GRANT create any index, create indextype to NOME_USUARIO_AQUI;
GRANT debug connect session to NOME_USUARIO_AQUI;
GRANT debug any procedure to NOME_USUARIO_AQUI;
GRANT DBA TO NOME_USUARIO_AQUI;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment