Hello,
I am new to using IFS Cloud in the cloud. I have always used IFS on prem. I went through the necessary steps and have received the ability via ifsinfo and ifsdbreadonly to get into the database via sql developer to do some select statements. However, I am coming across the problem where I can only do a SELECT statement on some views and not others.
EX: IFSAPP.CUSTOMER_ORDER returns nothing but IFSAPP.CUSTOMER_ORDER_ADDRESS returns normal information.
There are many more examples.
Why is this? Or how am I able to query all of the views without issue?
Thanks,
Eli
Question
IFSDBREADONLY/IFSINFO Querying Database
+6Hi
This might be because of the condition in the CUSTOMER_ORDER view that checks whether the user has access to the site used in the customer orders. Hence the users: ifsinfo and ifsdbreadonly that you use to log into the database might not have the access to the sites. Further I noticed that the view: CUSTOMER_ORDER_ADDRESS does not have this check on the site access which is why it is fetching the data.
Thanks,
Arosha
I’m running as a remote deployment if that helps.
+4Hi
Since IFSDBREADONLY is a database-only user, it doesn’t exist in the IFS Aurena. Therefore, site access may need to be granted from the database.
Thanks,
Sarasi
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.