Thursday, April 25, 2013

ORA-01031: insufficient privileges

ORA-01031: insufficient privileges error is caused due to invalid permission.

When happens on a Select/Insert/Delete/Update/Alter query, check if table has grants issued to the username trying to access.

For package make sure execute permission is given to username trying to access package. Even then if it does't work, use AUTHID CURRENT_USER on package spec.

No comments:

Post a Comment