Failed executing query (ORA-01031: insufficient privileges)

Hi @FPayab,
Please refer to KBA : 

Please provide feedback (like / helpfulness / response) on the article if it helps !

Hi @FPayab,
That is a bit odd, however what you could do to identify and resolute the issue with narrowing down the scope where problem exist is;

(1) Check if the issue is only specific to the user (can IFSAPP and other users access?)
(2) Create a new user (ABC) with basic admin grants and check if that new user could access
(3) If user ‘ABC’ could access the report, compare the difference in grants to identify the permission imbalance with the user. 

Sometimes in using an already created user we miss out assigned permission sets and grants so trying out the same with a new user provides us insights to what we may be missing. Also I hope following command executed successfully. 
BEGIN Installation_SYS.Grant_Ifssys(TRUE); END;

Hi @FPayab ,

I would be helpful if you can share the query here so that we can take a look to see if something pops out. 

Cheers

Hi @FPayab ,

Bit strange if that is the case.  Could it be something simple like a missing AO (ifsapp.) prefix in a API call or one of the views?

Are you able to run the select statement connected to the database as the end user account through a tool like Pl/SQL Developer or SQL Developer? These tools usually indicate for which view the user doesn’t have permissions so quite helpful to figure out where the actual issue is?

Cheers

Hi @FPayab,

What happens if you do the same test using pl/sql developer but logged in as IFSSYS user and see whether you can run the query? If that also works without any issues may be a worth doing a good old app server instance restart to clear out the connection pool. 

Cheers