I have two solutions hosted in the same server (say, solution A and solution B), each of them with their own set of user accounts.
I am trying to find a way for a B user to be able to run an a script that performs a query (using the Execute SQL function) that would return results from the solution A dataset with some conditions:
- Avoiding having to import records from one file to another.
- Avoiding keeping A and B users concurrently updated on both files.
I was thinking of ways to do a PSOS that can login with a dedicated account, so that the SQL query can perform being that this dedicated account would exist on both files. Has anybody have any suggestions?