MySQL Forums
Forum List  »  Stored Procedures

Access denied; you need (at least one of) the SUPER privilege(s)
Posted by: Irfan Ahamd
Date: January 16, 2020 07:53AM

We are using mysql 5.7.22 on centos and I have created user with this command:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER, CREATE TEMPORARY TABLES , CREATE ROUTINE, ALTER ROUTINE ,SHOW VIEW,EVENT
ON `s_ws`.* TO test@'%' IDENTIFIED BY 'Test@123';

GRANT SELECT ON mysql.proc TO test@'%'; FLUSH PRIVILEGES;

Now I want to create SP through above user with this definer (we cant remove definer clause `s_sp`@`localhost`):

DELIMITER $$

USE `s_ws`$$

DROP PROCEDURE IF EXISTS `aaa`$$

CREATE DEFINER=`s_sp`@`localhost` PROCEDURE `aaa`()
SQL SECURITY INVOKER BEGIN SELECT 'hello-world';

END$$

DELIMITER ;

Please suggest me.

Options: ReplyQuote


Subject
Views
Written By
Posted
Access denied; you need (at least one of) the SUPER privilege(s)
1607
January 16, 2020 07:53AM


Sorry, you can't reply to this topic. It has been closed.

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.