Grant Permission to Store Procs for Low level User

[Shabeer Ali Mohammed]

Pleae Help me regarding mysql permissions for a new user. A user can create , Alter and Execute store procs but shouldn't have the Table permisson. Mysql version I am runningi s 8.0

This is what I tried

--create a new user ( I need to give permissions to 3 users)
CREATE USER 'abc' @ 'localhost' IDENTIFIED BY 'xyz123abc' ;

--Grant execute on store procs
GRANT CREATE ROUTINE ON 'dbname.* TO 'abc'@'%';
GRANT ALTER ROUTINE ON 'dbname.* TO 'abc'@'%';
GRANT ALTER ON PROCEDURE dbname.sprocname TO 'abc'@'%';
GRANT EXECUTE ON PROCEDURE dbname.sprocname TO 'abc'@'%';

Thanks
S Ali