[MDEV-23003] INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION requires SUPER instead PROCESS privilege Created: 2020-06-17  Updated: 2021-09-30  Resolved: 2020-06-30

Status: Closed
Project: MariaDB Server
Component/s: Information Schema, Storage Engine - InnoDB
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.1.46, 10.2.33, 10.3.24, 10.4.14, 10.5.5

Type: Bug Priority: Major
Reporter: Muhammad Irfan Assignee: Eugene Kosov (Inactive)
Resolution: Fixed Votes: 1
Labels: None


 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



 Comments   
Comment by Julien Fritsch [ 2020-06-22 ]

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

Comment by Eugene Kosov (Inactive) [ 2020-06-30 ]

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

Generated at Thu Feb 08 09:19:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.