Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

MYSQL-Issue in accessing stored procedure globally by all users

Murugappan MurugappanApr 17 2019 — edited Apr 23 2019

Hi Team,

Whenever i am creating stored procedure SP1 in mysql workbench, Definer gets created automattically with my user name(user1) by default with the syntax 'username'@'hostname'. so stored procedure can accessed only by my user.

If i am logging from another user(user2)  and trying to access the stored procedure SP1. This user can't be able to access the stored procedure SP1.

My Assumption - The reason behind the issue is not able to access SP1 from user2 is due to that definer created automattically with the user name as user1.

Need solution - So whether there will be any possibility of restricting the definer creating automattically or Is there any way to give permissions to access SP1 by all users irrespective of definer restriction.

second question - for one user, i have not given drop and delete privilage. Eventhough that user able to drop and delete the stored procedure. how is ti possible and not able to use revoke command?

Thanks in Advance,

Murugappan Murugappan.

This post has been answered by Gaz in Oz on Apr 17 2019
Jump to Answer

Comments

Post Details

Added on Apr 17 2019
4 comments
405 views