Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1, 10.2, 10.3, 10.4, 10.5
-
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
|