Permissions for an Oracle USER

Asked

Viewed 579 times

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 ?

2 answers

3


Only use GRANT CONNECT, RESOURCE TO Aluno;

  • Puts! Thank you, gave sure, I killed myself thinking it was something much more complex !

0

GRANT PROCEDURE, CREAT, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE ON SCHEMA TO Student;

Well what is missing is the same CREATE.

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

Try this format, I think you just forgot one "And" no 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 GAVE IS NO CREAT also.

GRANT PROCEDURE, CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE ON SCHEMA TO Aluno;
  • and how to change now that it has been created ?

  • try using GRANT CREATE ON SCHEMA To Student;

  • No, that doesn’t work

  • I edited, see if now you can. If not, something wrong is not right. HEHHE hugs friend.

  • ORA-00990: Privilege not found or invalid 00990. 00000 - "Missing or invalid Privilege" *Cause: *Action:

  • This is usually a syntax error, strange. Haven’t you done anything else? If you don’t try to take CREATE out of REVOKE. This is very strange, unfortunately I’m not with the SGBD to test here.

  • you know how to drop the user ?

  • DROP USER Student CASCADE; Use CASCADE to cascade clean including user objects. Caution

  • It worked, then I created again, including fix CREATE, however, it still error saying that it lacks permissions

  • I gave a select on the permissions it showed me so CREATE SESSION and UNLIMITED TABLESPACE, what is missing ?

Show 5 more comments

Browser other questions tagged

You are not signed in. Login or sign up in order to post.