Bug #41180 Do not require the SUPER privilege to change the SESSION binlog_format
Submitted: 2 Dec 2008 18:19 Modified: 16 Jan 2009 16:54
Reporter: jocelyn fournier (Silver Quality Contributor) Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: Replication Severity:S4 (Feature request)
Version:5.1.30 OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[2 Dec 2008 18:19] jocelyn fournier 
Description:
Hi,

Following bug #41070, I think it would be nice to not require SUPER privilege to control the binlog_format.

Why not the REPLICATION SLAVE one ?

Thanks,
  Jocelyn

How to repeat:
SET SESSION binlog_format='ROW';
ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation
[16 Jan 2009 16:46] Susanne Ebrecht 
Many thanks for writing a feature request. There are tons of security reason why we won't change the behaviour.
[16 Jan 2009 16:54] jocelyn fournier 
Do you consider adding a new privilege in a next MySQL version to control this could be an option, or not at all ? (like the trigger privilege added in 5.1)