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)