Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

unexpected ORA-01031 "insufficient privileges" error fixed with recompile..

319958Dec 6 2010 — edited Dec 10 2010
Hello all,
We are experiencing a random error (random in that it occurs without known provocation -- no changes to packages/tables/etc and the error just pops up).
ORA-01031: insufficient privileges
ORA-06512: at "schema.packageName", line 831
ORA-06512: at line 10
01031. 00000 -  "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.
in this case, the actual 'culprit' to the problem was a SELECT col INTO varName from table within the procedure being called.

we verified that the user indeed had the correct rights/roles etc (http://asktom.oracle.com/pls/asktom/ASKTOM.download_file?p_file=6551289900368934430) for executing a select from table . The package is marked as compiled, but to 'fix' the problem it requires a re-compile.

So my question is this: what is causing this to occur? We have now seen this behavior about four times in the past two weeks, the most recent being from this past Sunday when there was no activity going on the oracle server (no new users/roles/packages/tables/code moves etc). is it possibly that the temp table schema is getting filled and this is the error?

Does anyone have any suggestion of what to check that may be causing this issue? it seems odd that we receive an ORA-01031 error that is related to a 'compilation' issue. any help would be highly appreciated (currently we are only seeing this in our staging env't but we fear it popping up in production)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2011
Added on Dec 6 2010
5 comments
8,176 views