SQL Mode per user?

[Mark Mokluk]

Is there any way that you can set the sql mode on a per user basis?

I'm aware that you can set the default sql mode and then change the sql mode after startup time on a per client basis by using:

SET SESSION sql_mode='modes'

From what I gather, this requires that either the client be aware that it is changing the sql mode by issuing the statement itself, or possibly by issuing the statement as an initial statement using the MySQL Connector/ODBC driver.

However, it would be useful if I could set the sql mode on a per user basis. I have several client apps that access the same database via different methods, including the MySQL ODBC and J (Type 4) drivers using a generic database user account. These clients would all require a sql mode change. Those clients also run on other DBMSs.

So, ideally, it easier if I could set the sql mode on a per user basis. That way the clients could be abstracted from having to detect the database and set the sql mode.

Any help would be appreciated.

Thanks.