User Roles

[Chris Gillepie]

Currently i'm working with MySQL 8.19 Community on linux. Developing a VB Studio app that uses stored procedures and functions on MySQL. Created a schema called vagt_db and two roles r_admin and r_basic.

CREATE ROLE r_admin, r_basic ;

GRANT Execute ON FUNCTION system_message TO 'r_admin';

GRANT 'r_basic' TO 'Test'@'%'


Unless I GRANT EXECUTE, SELECT ON vagt_db.* TO r_basic User Test cannot see the function. And at this point the user sees all Functions and Procedures not just the ones granted to r_basic. I followed what the online documents and tutorials say to do. Am I missing a step?