Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
13.1
-
None
-
Not for Release Notes
Description
CREATE DATABASE ev_db; |
CREATE USER ev_user@localhost; |
GRANT ALL PRIVILEGES ON ev_db.* TO ev_user@localhost; |
DENY EVENT ON ev_db.* TO ev_user@localhost; |
connect con1, localhost, ev_user,,ev_db; |
CREATE EVENT e1 ON SCHEDULE EVERY 1 HOUR DO SELECT 1; |
main.mytest [ fail ]
|
Test ended at 2026-06-09 18:31:04 |
CURRENT_TEST: main.mytest
|
mysqltest: At line 11: query 'CREATE EVENT e1 ON SCHEDULE EVERY 1 HOUR DO SELECT 1' succeeded - should have failed with error ER_DBACCESS_DENIED_ERROR (1044)... |
|
MTR Test to be added
--echo #
|
--echo # DENY EVENT privilege tests
|
--echo #
|
|
|
CREATE DATABASE ev_db;
|
CREATE USER ev_user@localhost;
|
GRANT ALL PRIVILEGES ON ev_db.* TO ev_user@localhost;
|
|
|
--echo #
|
--echo # DENY EVENT: blocks CREATE EVENT in database ev_db
|
--echo #
|
DENY EVENT ON ev_db.* TO ev_user@localhost;
|
|
|
connect (con1, localhost, ev_user,,ev_db);
|
--error ER_DBACCESS_DENIED_ERROR
|
CREATE EVENT e1 ON SCHEDULE EVERY 1 HOUR DO SELECT 1;
|
connection default;
|
disconnect con1;
|
Attachments
Issue Links
- is caused by
-
MDEV-14443 DENY clause for access control a.k.a. "negative grants"
-
- In Testing
-