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

After granting EXECUTE right with wildcard in dbname SELECT, INSERT, UPDATE and DELETE privileges can no longer be executed

Details

    Description

      Sample:
      GRANT SELECT, INSERT, UPDATE, DELETE ON test_1.* to user1@'192.168.122.10%';
      user1 can SELECT, INSERT, UPDATE and SELECT on tables in database test_1.
      After adding
      grant execute on `test_%`.* to user1@'192.168.122.10%';
      user1 gets permission denied when trying to access a table in test_1.
      Customer environment has several databases all with a suffix per client company and DBA wanted to grant EXECUTE permission for all databases in one statement.
      Workaround in this case:
      Explicitly GRANT EXECUTE for each database.

      Attachments

        Issue Links

          Activity

            I can't reproduce it right away, at least on the current 10.1.
            What does SHOW GRANTS say when you connect as user1?

            Please also attach your cnf file(s), maybe there is something in there.

            elenst Elena Stepanova added a comment - I can't reproduce it right away, at least on the current 10.1. What does SHOW GRANTS say when you connect as user1 ? Please also attach your cnf file(s), maybe there is something in there.

            People

              Unassigned Unassigned
              umoser Ulrich Moser (Inactive)
              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.