AnsweredAssumed Answered

Performing Execute SQL scripts at a foreign file (within same server)

Question asked by ricardocpa on Feb 6, 2017
Latest reply on Feb 7, 2017 by wimdecorte



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?