Permissions for an Oracle USER

Navigation
1

I am creating an Oracle user for my bank, after defining the basics I tried to execute my script to create the tabelas and sequences , however, the tool returned an error saying it lacked permissions.

The error: 

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 defined 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 do I need to create the sequences, tables, and other basic activities?

    
asked by anonymous 20.07.2017 / 23:37

2 answers

3

Only use GRANT CONNECT, RESOURCE TO Aluno;

    
21.07.2017 / 01:05
0
  GRANT PROCEDURE, CREAT , DROP, ALTER, SELECT, INSERT, UPDATE, DELETE ON SCHEMA TO Student;

Well, what's missing is CREATE anyway. 

GRANT PROCEDURE, CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE ON SCHEMA TO Aluno;

Try this format, I think you just forgot an "E" in CREATE.

Give a revoke: 

REVOKE PROCEDURE, CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE ON SCHEMA FROM Aluno;

And again give the correct instructions, remember that the REVOKE I GIVE IN CREAT also. 

GRANT PROCEDURE, CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE ON SCHEMA TO Aluno;
    
20.07.2017 / 23:43
Difficulty in passing parameters and arguments in callback What is the best way to generate random code that is not repeated in the database? [duplicate]