Database - The current user does not have required roles for this operation

Hello,
Ignition 7.9
I have seen several topics similar to this one, but having tried all of the solutions detailed, nothing seems to work.
I am trying to query a database, the query works in designer, the query works in Script Console, but it does not work once published.

Error executing function ‘RunQuery’: The current user does not have the required roles for this operation.

In Project Properties, I have “Legacy Database Access” Enabled.
I also have also restarted Ignition several times, as well as deleting my .ignition folder and restarting.

An interesting aspect of this as well, that I don’t see in other topics, is when I set the Default Database to the one I am querying, and use the Database Query Browser, I am not able to see default, but I am able to see the normal connection (ie the same Database, just not under ).

In other Projects, everything works fine.

Any help would be appreciated.
Thank you.