How to solve ora 01031 insufficient privileges in Oracle?

Go to User > User.
Select the user in the list.
Right-click the user and choose Edit User.
In the Server Privileges tab, check "CREATE TABLE"
Click Save.
Lees verder »

Bron: help.navicat.com

What is Ora-01031 insufficient privileges error in Oracle?

The ORA-01031 error means that the user receiving this error lacks a privilege to create an object, usually a table or view. When browsing the attribute elements to create the attribute qualification filter or to answer the prompt, the SQL Generation Engine needs to store the results in a temporary table. Lees verder »

Bron: community.microstrategy.com

How to resolve deadlock error in Oracle?

Ask the session getting deadlock error ORA-00060 to issue either COMMIT or ROLLBACK.
Ask the waiting session to kill the SQL / transaction.
Look inside alert log / trace file for the sessions involved in deadlock and inform application team to improve the code.
Lees verder »

Bron: support.dbagenesis.com

What is Ora-01031 insufficient privileges while compiling a procedure?

An "ORA-01031: insufficient privileges." Error Occurs When Performing an Action. This error can occur if the Oracle user for Laserfiche is granted privileges solely through roles. Oracle privileges granted through roles are not available when compiling stored procedures, functions, and packages. Lees verder »

Bron: support.laserfiche.com

How to handle raise_application_error in Oracle?

You must have assigned error_code to the user-defined exception with the EXCEPTION_INIT pragma. ...
The error_code is an integer in the range -20000.. ...
For semantic information, see "EXCEPTION_INIT Pragma".
The message is a character string of at most 2048 bytes.
Lees verder »

Bron: docs.oracle.com

Gerelateerd aan How to solve ora 01031 insufficient privileges in Oracle?