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:
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:6.0 OS:Linux
Assigned to: Marc ALFF CPU Architecture:Any

[15 May 2009 9:36] Guilhem Bichot
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.
[15 May 2009 14:29] Guilhem Bichot
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'
[3 Jun 2009 18:19] Marc ALFF
Fixed with:
bzr commit into mysql-6.0-perfschema branch (marc.alff:3158)
[26 Jun 2009 9:12] Guilhem Bichot
runtime team will be better-suited for reviewing this.
[4 Nov 2009 23:27] Bugs System
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:


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.
[1 Dec 2009 21:42] Marc ALFF
Reviewed by Dmitry with the SQL_ACL changes
[1 Dec 2009 21:43] Marc ALFF
Queued in mysql-trunk-perfschema
[14 Jan 2010 10:03] Marc ALFF
Merged in:
- mysql-next-mr (Celosia / 5.5.99-m3)
- mysql-6.0-codebase (6.0.14)
[14 Jan 2010 18:05] Paul DuBois
Not in any released version. No changelog entry needed.