> hi there i'm having troubles to find how to > GRANT SELECT ON all-tables-onmydb TO specificuser
There isn't any such command. You need to write a stored procedure to do it for you in a loop.
Chris