Home » RDBMS Server » Security » ORA-01031 permission denied (RDBMS 12C Linux RAC)
ORA-01031 permission denied [message #689247] Fri, 27 October 2023 10:15 Go to next message
pookie1
Messages: 5
Registered: June 2023
Junior Member
Hello all
In on our application we get ORA-01031 in the log,  but we don't know  which object it corresponds to. In oracle  database is there a table or a way of seeing which object we got permission denied on?
Re: ORA-01031 permission denied [message #689248 is a reply to message #689247] Fri, 27 October 2023 10:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01031: insufficient privileges
 *Cause: An attempt was made to change the current username or password
         without the appropriate privilege. This error also occurs if
         attempting to install a database without the necessary operating
         system privileges.
         When Trusted Oracle is configure in DBMS MAC, this error may occur
         if the user was granted the necessary privilege at a higher label
         than the current login.
 *Action: Ask the database administrator to perform the operation or grant
          the required privileges.
          For Trusted Oracle users getting this error although granted the
          the appropriate privilege at a higher label, ask the database
          administrator to regrant the privilege at the appropriate label.
Re: ORA-01031 permission denied [message #689249 is a reply to message #689248] Fri, 27 October 2023 11:51 Go to previous messageGo to next message
pookie1
Messages: 5
Registered: June 2023
Junior Member
weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizationListener@2cf3f5a8
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20201109-7e11866): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.UpdateException: ORA-01031: insufficient privileges

how to find out which object?
Re: ORA-01031 permission denied [message #689250 is a reply to message #689249] Fri, 27 October 2023 12:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You should know which part of which procedure pf your application returns the error.

Re: ORA-01031 permission denied [message #689251 is a reply to message #689250] Fri, 27 October 2023 13:52 Go to previous messageGo to next message
pookie1
Messages: 5
Registered: June 2023
Junior Member
ha so there isnt any other way of finding out where the problem is other then via application logs?
thank you!!!!
Re: ORA-01031 permission denied [message #689252 is a reply to message #689251] Fri, 27 October 2023 14:07 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No, afaik, Oracle does neither trap nor record the root (object, action...) of this error.

Previous Topic: Security & Encryption
Next Topic: Decrypt programmatically when TDE is enabled
Goto Forum:
  


Current Time: Thu Apr 18 12:22:27 CDT 2024