Bug #140 | A bug in checking privileges with multi-table updates | ||
---|---|---|---|
Submitted: | 10 Mar 2003 7:10 | Modified: | 10 Mar 2003 7:10 |
Reporter: | SINISA MILIVOJEVIC | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 4.0 | OS: | Any (ALL) |
Assigned to: | CPU Architecture: | Any |
[10 Mar 2003 7:10]
SINISA MILIVOJEVIC
[10 Mar 2003 7:10]
MySQL Verification Team
Fixed
[16 Sep 2003 6:50]
Marco Kranz
This bug also happens with MySQL 4.1.0-alpha-max-nt. e.g. INSERT INTO dbtable (something,else) VALUES ((SELECT something),'else') #1142 - insert not allowed for: 'user@127.0.0.1' for table 'dbtable' The user has full rights to the db, but it seems mysql uses the table-rights. After I have added these rights it works fine.