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

INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION requires SUPER instead PROCESS privilege

    XMLWordPrintable

    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

            People

            Assignee:
            kevg Eugene Kosov
            Reporter:
            muhammad.irfan Muhammad Irfan
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: