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

INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION requires SUPER instead PROCESS privilege

Details

    Description

      I noticed that, INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION requires SUPER instead PROCESS privilege.
      As per documentation https://mariadb.com/kb/en/information-schema-innodb_tablespaces_encryption-table/

      Viewing this table requires the PROCESS privilege.

      That's how it look likes:

      GRANT SELECT, PROCESS ON *.* TO 'irfan'@'localhost' IDENTIFIED BY PASSWORD '*45CBF3BB1F5BDCFBF443A484587177336B4880D5'
      		 
       
      		 
      MariaDB [(none)]> select current_user(), user();
      		 
      +-----------------+-----------------+
      		 
      | current_user()  | user()          |
      		 
      +-----------------+-----------------+
      		 
      | irfan@localhost | irfan@localhost |
      		 
      +-----------------+-----------------+
      		 
       
      		 
      MariaDB [(none)]> SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION;
      		 
      ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          julien.fritsch Julien Fritsch added a comment -

          In Marko's absence kevg is that for your team?

          julien.fritsch Julien Fritsch added a comment - In Marko's absence kevg is that for your team?
          kevg Eugene Kosov (Inactive) added a comment -

          Yes, this is for InnoDB team. And the bug existed since the very beginning of the feature https://github.com/MariaDB/server/commit/d7d589dc01f6d70d1518b74d46fd3b75e76267f5#diff-b0accd8289ff6ab84ead1e7371b44f67R8230

          kevg Eugene Kosov (Inactive) added a comment - Yes, this is for InnoDB team. And the bug existed since the very beginning of the feature https://github.com/MariaDB/server/commit/d7d589dc01f6d70d1518b74d46fd3b75e76267f5#diff-b0accd8289ff6ab84ead1e7371b44f67R8230

          People

            kevg Eugene Kosov (Inactive)
            muhammad.irfan Muhammad Irfan
            Votes:
            1 Vote for this issue
            Watchers:
            5 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.