Example;

For example, using:

GRANT PROCESS ON table_name TO soasta_user; FLUSH PRIVILEGES;

So that, if the soasta user were called "monitor" in the database, and the tables you needed to monitor were: "users", "orders", and "products", it should be:

GRANT PROCESS ON users,orders,products TO monitor;

For more complex setups, involving MANY tables, you can use:

GRANT PROCESS ON *.* TO monitor;

Note: Ensure that the flush privileges query is run after the grant, and then verify the process privilege is there with:

SHOW GRANTS FOR 'monitor';