I’m not a Crystal Reports expert, but in
https://docs.ifs.com/techdocs/23r2/070_remote_deploy/400_installation_options/005_operational_reporting/110_configure_crystal_web_service/010_setup_cws/
the IFSINFO user is used against Oracle database from Crystal Reports.
(the page looks like a component to display CR reports in IFS, but that would be a good guess for the user)

IFSINFO is also used in for example BI solutions to do read-only fetches from the Oracle database.
It has access to IFS Information Sources through Access Views that you can configure through IFS.

SamiL,

as am sure I could use some builtin IFS% accounts you will understand that this will not be an ideal way to do anything in a database for accountability and security reasons to name a couple...

coming from apps9 where there were oracle users and permissions were granted thru the application interface...this is no longer the case in cloud “remote” so what is IFS’ substitute for this? odata? REST? IAM? how do we make the db connection from crystal?

@gabdarielc ,

Please see this post

Let me know if you need more info

Regards

Pankaj

paguin, how is that relevant to my question? please explain?

I am not getting any errors or have any issues with crystal webservices or quick reports

I assume you mean how to connect the Crystal Reports designer tool (it’s been years since I touched that) to the database. As mentioned by SamiL, there is still and Oracle database account for the user IFSINFO, which has read access to all IFS database views etc., but I guess it depends on whether you’re happy to share that between developers or not.  

Aussie, I dont think IFSINFO has access to all views (at least not on my setup) mind you I am not hosted in the cloud so maybe that is different if the db is hosted in the cloud

but also, the idea that I will have an account with read access to all views just plain scares the crap out of me and I am sure that this is not IFS’ best practice (I hope not)

In the end looks like the answer to my question is not as simple as I hoped it to be I am surprised that no one else is bothered by this

I guess for now, I will have to go with my own solution on this one.

Beta