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.
<-------------------done--------------------------->
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.
<-------------------done--------------------------->
ora-01031: insufficient privileges linux
ora-01031 insufficient privileges create table
ora-01031: insufficient privileges rman
ora-01031 insufficient privileges create view
ora-01031: insufficient privileges windows
sap ora-01031: insufficient privileges
ora-01031 insufficient privileges in oracle
ora-01031 insufficient privileges materialized view
0 comments