MySQL Forums
Forum List  »  Stored Procedures

Grant Permission to Store Procs for Low level User
Posted by: Shabeer Ali Mohammed
Date: November 18, 2021 01:05AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Grant Permission to Store Procs for Low level User
424
November 18, 2021 01:05AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.