SELECT Permission Denied When Consuming User Profile Service Application

**Updated to include the officially supported method** While setting up a repro scenario a month or so ago I encountered an interesting issue with consuming the User Profile Service Application (UPSA). And by interesting, of course I mean maddening… It appears that the documentation around how to consume a shared User Profile Service Application is…

2