MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Re: logon trigger to restrict login from workbench
Posted by: Georgi Kodinov
Date: March 02, 2018 03:59AM

Forgot the GRANT !

grant execute on procedure mysql.p1 to u1@localhost;

Users without this grant can't execute p1 so they can't login.

Georgi "Joro" Kodinov
MySQL SrvGen team lead
Plovdiv, Bulgaria

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
logon trigger to restrict login from workbench
3005
Allison Harden
January 30, 2018 01:05PM
Re: logon trigger to restrict login from workbench
1327
Peter Brawley
January 30, 2018 01:14PM
Re: logon trigger to restrict login from workbench
987
Allison Harden
February 01, 2018 11:56AM
Re: logon trigger to restrict login from workbench
1278
Georgi Kodinov
March 02, 2018 03:36AM
Re: logon trigger to restrict login from workbench
968
Georgi Kodinov
March 02, 2018 03:59AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.