MySQL Forums
Forum List  »  Triggers

logon trigger to restrict login from workbench
Posted by: Allison Harden
Date: January 30, 2018 01:05PM

How can I use a logon/login trigger to restrict access to end-users from tools like the mysql shell and workbench...or to allow login only from an ODBC connection (ms access application file DSN)? Ultimately I want to only allow a group of users to login to mysql server via the File DNS from an application to maintain the application's data integrity features and/or prevent them from logging on with workbench etc. and directly changing data in the tables.

Options: ReplyQuote

Written By
logon trigger to restrict login from workbench
January 30, 2018 01:05PM

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.