ourdelta-developers team mailing list archive

[Arjen Lentz <arjen@xxxxxxxxxxxxx>]

Hi Rob

On 02/08/2009, at 8:07 AM, Wultsch wrote:
> mysql> select * from information_schema.INNODB_BUFFER_POOL_CONTENT;
> ERROR 1227 (42000): Access denied; you need the SUPER privilege for
> this operation
> [...]
> I could probably get the behavior to be less restrictive if that would
> be needed. Perhaps anyone with select on a table should be able to see
> if it is the buffer pool? What does everyone think?


Nah, I think this is clearly the kind of command/info that a regular  
user really shouldn't need to be able to touch, so why spend more time  
on it. Securing it just for users with SUPER privs looks fine to me.

Vadim, will you incorporate this?

Cheers,
Arjen.
--
Arjen Lentz, Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at a fixed budget.

Follow our blog at http://openquery.com/blog/
OurDelta: free enhanced builds for MySQL @ http://ourdelta.org