Skip to main content

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

Hi ​@Ewilliams ,

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


@Arosha Mudalige, do you know if it’s possible to grant `ifsdbreadonly` access to sites? I’m running into this issue, specifically with the `INVENTORY_PART` view as well. The `ifsdbreadonly` user doesn’t show up in the Aurena side of things so I can’t add it in via Sites per User. 

 

I’m running as a remote deployment if that helps.


Hi ​@mRiston,

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


Reply