ERROR: '' You do not have permissions to run native ad-hoc queries against database 3. ''

Greetings everyone.
I can’t say for sure what caused the issue, but I encountered the same.
While users are able to execute all kind of queries, they were unable to save Questions unless they were the SQL kind or they were Administrators - this was present only for BigQuery Datasources.

There were three variables for us: we updated metabase version to 36.x, migrated from .jar execution to Docker (didn’t change the Metabase Database), updated BigQuery access from OAuth to Service Accounts.

The workaround: created new User Groups.
Switching Group permissions on and off or adding and removing users from groups did not work, but creating a new group did.

I will keep you posted if I find more information.

Edit: i checked the permissions_group, permissions and permissions_group_membership and didn’t find any difference between the records of previously existing groups and the new one.

Regards