Skip to main content
Question

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

B
Superhero (Employee)
Forum|alt.badge.img+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.

T
Hero (Employee)
Forum|alt.badge.img+8
  • Telha
  • Hero (Employee)
  • December 5, 2023

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
Superhero (Employee)
Forum|alt.badge.img+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
Hero (Employee)
Forum|alt.badge.img+8
  • Telha
  • Hero (Employee)
  • December 6, 2023

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

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings