Forum Stats

  • 3,734,269 Users
  • 2,246,935 Discussions


Misleading error text?

EdStevens Member Posts: 28,143 Gold Crown
edited May 15, 2015 3:03PM in SQL

Oracle Std Ed.

Oracle Linux 5.6 64-bit

User presents a query that references a function from another schema and a function within a package from yet another schema.  He only had EXECUTE on the first, but not the second, so got an ORA-01031.  Fair enough, but look at what Oracle has to say about that particular error:

oracle:dwdev$ oerr ora 1031

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.

Full text appears to be a bit of a narrow interpretation of what can trigger the specified error.

I'm just sayin' . . .

It is Friday afternoon ...

Sign In or Register to comment.