How to ban changes sql_mode on session level
Posted by: Aleksey Filippov
Date: January 26, 2017 07:45AM

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?

Options: ReplyQuote

Written By
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.