Re: logon trigger to restrict login from workbench
A MySQL Trigger can be defined only for Insert, Update and Delete SQL commands.
To restrict non-admin MySQL login to a particular app,
- define a user/password combo specifically for that app
- have that app issue its own passwords for its users, authenticating them against its own password table
- do not publish mysql passwords for root or other admin users
Subject
Views
Written By
Posted
3052
January 30, 2018 01:05PM
Re: logon trigger to restrict login from workbench
1348
January 30, 2018 01:14PM
1008
February 01, 2018 11:56AM
1308
March 02, 2018 03:36AM
995
March 02, 2018 03:59AM
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.