Stack Overflow
Stack Overflow

Questions tagged [ora-01031]

The ORA-01031: insufficient privileges error occurs when a user attempts to execute a program or function for which he has not been granted the appropriate privileges.

Error: ORA-01031: insufficient privileges

Cause: A user attempted to perform an operation for which he does not have the appropriate privileges. Some of the most common causes are:

  • The user tried to change an Oracle username or password without having the appropriate privileges.
  • The user tried to perform an UPDATE to a table, but he only has SELECT access to the table.
  • The user tried to start up an Oracle database using CONNECT INTERNAL.
  • The user tried to install an Oracle database without having the appropriate privileges to the operating-system.

Action: The options to resolve this Oracle error are:

  • The user can have the Oracle DBA grant him the appropriate privileges that he is missing.
  • The user can have the Oracle DBA execute the operation for him.
  • If the user is having trouble starting up Oracle, he may need to add the Oracle user to the dba group.
19 questions
3
votes
3 answers

01031. 00000 - "insufficient privileges" while granting System Privileges to the new user

I created a new connection in Oracle SQL Developer. Under this new connection, I created a new user. Now, I'm trying to grant roles and System privileges to this new user. I get the following error while trying to grant system privileges to the new…
santobedi
  • 866
  • 3
  • 17
  • 39
3
votes
2 answers

'ORA-01031: insufficient privileges' error received when inserting into a View

Under the user name 'MY_ADMIN', I have successfully created a table called 'NOTIFICATIONS' and a view called 'V_NOTIFICATIONS'. On the 'V_NOTIFICATIONS' view I have successfully created a trigger and a package that takes what the user attempts to…
Patrick K
  • 179
  • 3
  • 14
2
votes
2 answers

ORA-01031 in insert

i was running an insert query on a synonym i got ORA-01031 in sql developer, we are accessing almost all tables through synonym only, but only this one in the schema gave ORA-0103 error. Please guide. Error report: SQL Error: ORA-01031: insufficient…
sij
  • 1,307
  • 7
  • 18
  • 35
2
votes
2 answers

Oracle & making a reference to ALL_USERS(USERNAME)

So i need to do a mapping from a Employee table (idEmployee, name, etc..) to a real user with a account created. I decided to add a table Mapping_Employee_User(idEmployee, userName) like below CREATE TABLE Mapping_Employee_User( idEmployee…
Iftimie Vlad
  • 199
  • 1
  • 2
  • 12
2
votes
1 answer

ORA-01031: insufficient privileges when inserting via dblink

This works: (connect to some_db) INSERT INTO some_schema.some_table(id) VALUES (some_schema.some_table.nextval); THis works too: (connect to some_other_db) SELECT some_schema.some_table.nextval@some_db FROM DUAL; This does not work: (connect to…
Tgr
  • 27,442
  • 12
  • 81
  • 118
2
votes
2 answers

ORACLE - Create Procedure granted but can't create procedure

There's a user in the database to whom CREATE PROCEDURE privelege is granted. But when that user tries to create a simple procedure the following error is thrown: ORA-01031: insufficient privileges 01031. 00000 - "insufficient privileges" *Cause: …
Mikayil Abdullayev
  • 12,117
  • 26
  • 122
  • 206
1
vote
1 answer

Oracle Trigger Permissions

I want to create a trigger owned by user A for a table that is owned by user B. What permissions must I set on B.table to avoid an ORA-01031: insufficient privileges error?
Jeff
  • 8,020
  • 34
  • 99
  • 157
1
vote
0 answers

CUSOR / SYS_REFCUSOR Problems/ BUG on Oracle 19c

we have several problems with Cursors and SYS_REFCURSOR. In Version 12.2.0.1 everything works fine. We installed a fresh system with 19.8.0.0 and nothing was migrated. We use a function to concatenate each value per row given by a query into a…
Reporter
  • 38
  • 5
1
vote
1 answer

Invalid privilege error?

Two related applications use a function in a package in several queries to return some data as CSV. The column being selected and concatenated is a CLOB field and can contain HTML, special characters, etc. The applications have few users and so are…
Zesty
  • 2,922
  • 9
  • 38
  • 69
1
vote
1 answer

Importing sql file to a new user throws insufficient privilege error in sqldeveloper

I have created a user in AWS oracle RDS and have my tables,functions and all other code. As I needed the same replica of this DB structure, I exported it to an sql file using SQL Developer. Created another user, and now want to import the sql file…
XSL Query
  • 11
  • 4
1
vote
1 answer

ORA-01031: insufficient privileges while inserting through procedure

I have two Oracle DB schemas SCHEMA1 and SCHEMA2 in same instance. Objects in SCHEMA1 : 1. A procedure PROC_ABC. Objects in SCHEMA2 : 1. A table TABLE_DEF. 2. A Trigger TRIG_DEF. Grants : 1. Grant insert any table to SCHEMA1 by SYSTEM user. 2. Grant…
Abhishek
  • 31
  • 2
  • 5
1
vote
1 answer

ORA-01031: insufficient privileges at "SYS.DBMS_SESSION" when using a package on 11g

I have a package with a procedure to create context and set the value to context. It works very well on 10g but on 11g I get the following error also with DBA role. ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SESSION", line…
user4878596
1
vote
2 answers

ORA-01031: Message 1031 not found; No message file for product=RDBMS, facility=ORA

While trying to connect to Oracle database with sqlplus / as sysdba, I get the following error: ORA-01031: Message 1031 not found; No message file for product=RDBMS, facility=ORA I am using Windows environment. How I can correct this?
user2199560
  • 11
  • 1
  • 1
  • 3
0
votes
1 answer

Delete From table ; ORA-01031: insufficient privileges

I have a table with only one field: id_acteur_fk. When I want to delete a line by this request ; DELETE gros_postes WHERE id_acteur_fk = '325' I get this error : ORA-01031: insufficient privileges
reda Sabbane
  • 1
0
votes
0 answers

ORA-01031: insufficient privileges for Oracle view

We are running Oracle database 19c and we have got a strange error for ORA-01031: insufficient privileges There are two users/schemas, for short, I call them mgr and user here. So on mgr, I have created this view: CREATE OR REPLACE FORCE…
user2526586
  • 972
  • 2
  • 12
  • 27
1
2