Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.6
-
None
-
Not for Release Notes
Description
User with UPDATE only privilege (no SELECT) can't prepare UPDATE
Example mtr (succeeds when run normally, fails with --ps-protocol)
CREATE TABLE t1 (a INT, b INT); |
INSERT INTO t1 VALUES (1, 1); |
|
|
CREATE USER u@localhost; |
GRANT UPDATE ON test.t1 TO u@localhost; # UPDATE only, no SELECT |
|
|
--connect (con1, localhost, u,, test)
|
|
|
# Non-PS: succeeds (no columns are read) |
# PS mode: fails with ER_COLUMNACCESS_DENIED_ERROR (SELECT denied) |
UPDATE t1 SET b = 2; |
--connection default
|
DROP USER u@localhost; |
DROP TABLE t1; |