MySQL Bugs: #44898: PerformanceSchema: can create a table in db performance

Bug #44898	PerformanceSchema: can create a table in db performance_schema, cannot insert
Submitted:	15 May 2009 9:36	Modified:	14 Jan 2010 18:05
Reporter:	Guilhem Bichot	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Performance Schema	Severity:	S3 (Non-critical)
Version:	6.0	OS:	Linux
Assigned to:	Marc ALFF	CPU Architecture:	Any

Description:
use performance_schema;
mysql> create table t(a int);
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t values(1);
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'performance_schema'

I guess the ideal behaviour would be that people would not be allowed to create the table.
I believe this is not a high-priority problem (a user would realize that all she/he can do is drop this table).

A checking on the table's name could be a solution.

How to repeat:
see description.

If in database information_schema, one gets:
mysql> create table t(a int);
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'information_schema'

Fixed with:
bzr commit into mysql-6.0-perfschema branch (marc.alff:3158)

runtime team will be better-suited for reviewing this.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/89382

2941 Marc Alff	2009-11-04
      Bug#44898 Performance Schema: can create a table in db performance_schema, cannot insert
      
      Enforced table level privileges for unknown performance_schema.* tables,
      to deny any operation on non performance schema tables.

Reviewed by Dmitry with the SQL_ACL changes

Queued in mysql-trunk-perfschema

Merged in:
- mysql-next-mr (Celosia / 5.5.99-m3)
- mysql-6.0-codebase (6.0.14)

Not in any released version. No changelog entry needed.