There is a console application written that we cannot change the source code for. It is a very simple application. Somewhere in the application it has a stament along the lines of
SELECT FieldABC FROM Carriers
This is referencing a database from a vendor application. During a recent upgrade, the Carriers table became part of the 'PM' schema and now needs to be referenced as PM.Carriers.
Is there a way I can set it up so that the statement above will work. Right now it is failing with an error saying Carriers does not exist. I explicitly granted the SQL login the console application uses SELECT permission on the table - but it still did not work.
Any help is appreciated.