10 Replies Latest reply on Feb 7, 2017 9:22 AM by wimdecorte

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




      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?