1
I am creating an Oracle user for my database, after setting the basics I tried to run my script to create the tabelas
and sequences
, however, the tool returned me an error saying missing permissions.
the mistake:
Relatório de erros -
ORA-01031: privilégios insuficientes
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to perform a database operation without
the necessary privileges.
*Action: Ask your database administrator or designated security
administrator to grant you the necessary privileges
I set the following permissions:
Edit: (error persists)
GRANT CREATE TRIGGER, CREATE SEQUENCE, CREATE PROCEDURE, CREATE TABLE, CREATE SESSION, UNLIMITED TABLESPACE, EXECUTE ANY PROCEDURE, SELECT ANY DICTIONARY, SELECT, INSERT, UPDATE, DELETE, REFERENCES, ALTER, INDEX, EXECUTE ON SCHEMA TO Aluno;
What permissions would be required (missing) to create the sequences, tables and other basic activities ?
Puts! Thank you, gave sure, I killed myself thinking it was something much more complex !
– AlunoOracle