Question

The SQL query generated for a specific user in the 'Time Authorization' window cannot be executed

  • 5 December 2023
  • 3 replies
  • 30 views
B
Rank
Userlevel 5
Badge +13

I have logged into the IFS App 10 Aurena as user TEST and have extracted the underlying query which popuates the data in the ‘Time Authorization’ window (it populates the relevant data in the window).

 

When running this query directly in the DB logged in as user TEST produces the error “ORA-01031: insufficient privileges”.

The same error is observed when running the query in SQL Query Tool in IEE as user TEST.

How can we resolve this issue?

Note: We must run this query as user TEST. Further the TEST user has been provided the IFS_FULL permission set as well.

3 replies

T
Rank
Userlevel 2
Badge +8

Hi,

 

Does the query have the “IFSAPP.” prefix on all of the views/API functions? e.g.

 

Is the query using any tables i.e. “_TAB” in the FROM section? If so can you try to remove the “_TAB” and see if that works.

 

Regards

 

Telha

B
Rank
Userlevel 5
Badge +13

Hi @Telha,

Views are utilized in the FROM clause.
If the views doesn’t use the “IFSAPP.” it produces the error ‘Table or View doesn’t exist’ error.

Hence appended all the views with “.IFSAPP”. However now getting the error ‘ORA-01031: insufficient privileges’.

Best Regards,
Bhagya

T
Rank
Userlevel 2
Badge +8

HI @Bhagya Wickramasinghe,

 

Is it possible to post the SQL?

 

Also could you check if the IFS_ALL permission set is granting the API and views used in the query. e.g.

 

 

Regards

 

Telha

Reply


Terms & ConditionsCookie settings