Created
August 13, 2018 16:53
-
-
Save igorsgm/70e133275270f3e2c1ff95c1f96a625f to your computer and use it in GitHub Desktop.
#Criar novo Usuário e Schema no Banco de Dados Oracle
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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