Bug #42124 | sql_mode should be integrated into privileges system | ||
---|---|---|---|
Submitted: | 15 Jan 2009 6:29 | Modified: | 15 Jan 2009 8:17 |
Reporter: | Shlomi Noach (OCA) | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: General | Severity: | S4 (Feature request) |
Version: | 4.1, 5.0, 5.1 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | SQL_MODE |
[15 Jan 2009 6:29]
Shlomi Noach
[15 Jan 2009 6:59]
Valeriy Kravchuk
I think this is a duplicate of bug #42034.
[15 Jan 2009 8:17]
Shlomi Noach
While the issue arises from a similar place, the suggested solution is different. While Roland Bouman suggests: GRANT SET SQL_MODE ... TO ... which allows for a user to change her session sql_mode, I suggest: GRANT ZERO_IN_DATE ON ... TO ... Which allows for users to set zero in date for given schemas, tables, columns. It has nothing to do with changing the sql_mode itself. And so the feature request which I suggest is different from the feature request in [http://bugs.mysql.com/bug.php?id=42034].