Found the issue after a lot of fiddling.

The user did not have the correct permissions to perform a SELECT on the profiles table. Now the permissions work as intended.