Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-39951

DENY feature does not work for EVENT privilege

    XMLWordPrintable

Details

    • 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

          Activity

            People

              wlad Vladislav Vaintroub
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.