Add method to user for execute certain queries only

Hi, is it possible to add a method for less permissions?

Currently, a group has full access to the entire database,

The idea is only to grant access to “certain” queries that the administrator has made,

You usually have sensitive data in the same database, you have some reports that you need, of course you can add a proxy to encrypt that,

But the idea is to be more precise when granting access,