How to ban changes sql_mode on session level
Hi. Help please with problem.
We have global variable sql_mode set to STRICT_ALL_TABLES(mysqld.cnf).
But someone changes this variable on session level, and from time to time we have problem with data in our database...
Is there some ability to ban users to change sql_mode by setting 'set session ', or other way, some kind of force setting?
Subject
Written By
Posted
How to ban changes sql_mode on session level
January 26, 2017 07:45AM
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.