Skip to main content
Solved

IFSDBREADONLY/IFSINFO Querying Database

  • March 18, 2025
  • 6 replies
  • 457 views
Do Gooder (Customer)
Forum|alt.badge.img+1

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

Best answer by sdhalk

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

    6 replies

    Arosha Mudalige
    Do Gooder (Employee)
    Forum|alt.badge.img+6

    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

      Sidekick (Customer)
      Forum|alt.badge.img+5
      • mRiston
      • Sidekick (Customer)
      • April 4, 2025

      ​@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.

      sdhalk
      Hero (Employee)
      Forum|alt.badge.img+7
      • sdhalk
      • Hero (Employee)
      • Answer
      • April 4, 2025

      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

        untsrikanth
        Sidekick (Customer)
        Forum|alt.badge.img+4
        • untsrikanth
        • Sidekick (Customer)
        • September 15, 2025

        ​@sdhalk If it is a managed instance, we only have access to the database using the IFSDBREADONLY user. In that case, how should we handle it?

        ~Sri
        Superhero (Partner)
        Forum|alt.badge.img+17
        • knepiosko
        • Superhero (Partner)
        • September 15, 2025

        I don't understand above explanation. IFS prevents any db activity but if there is a real problem does not provide solution to do it from application side and suggest something like this. What is the real approach?

        May I ask You ​@sdhalk to clarify this and provide official IFS standards?

        Piotr --> https://www.linkedin.com/in/piotr-skowronek-8425aa6/
        Jonas Feigl
        Superhero (Employee)
        Forum|alt.badge.img+20
        • Jonas Feigl
        • Superhero (Employee)
        • September 15, 2026

        The given response in this post is incorrect. You can create the IFSDBREADONLY user as an end user in the application and then grant sites, companies, etc. These will then also apply when logging on to the database directly.

        Terms & ConditionsAccessibility statement