Hi ,
IFS recommended to use Access views to export data from IFS Cloud environment hosted by IFS. The recommended user account is IFSINFO.
Now the question is, since most data sources have row level security (Company/site/ HR access) some data are not visible to IFSINFO schema user by default.
What is the recommendation here ?
Q1. Should IFSINFO be registered as an employee with supervisor access to fetch all employee data from access view ?
Thanks,
Rohana
The documentation seems to support that idea, that the user accessing the data needs to have the correct permissions. But is also says that identical views owned by the IFSINFO user are created for each Access View. You’d have to take a look at those IFSINFO views and see what the security checks are in those. It’s been a while, but last time I checked, some of the security clauses for HR and Finance had the option of the user simply having admin rights to see the data.
Hi,
You can use Information Source Full Access page to control/configure row level access grants to the users.
IFSINFO user (the user specified in Information Access Layer (IAL) Oracle user system parameter) has the full access granted to that user by default. So if you are using IFSINFO to connect you should see all the data.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.