Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 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
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Thirunarayanan Balathandayuthapani [ thiru ] |
| Assignee | Thirunarayanan Balathandayuthapani [ thiru ] | Eugene Kosov [ kevg ] |
| Key |
|
|
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 10.3 [ 22126 ] | |
| Affects Version/s | 10.4 [ 22408 ] | |
| Affects Version/s | 10.5 [ 23123 ] | |
| Affects Version/s | 10.4 [ 23604 ] | |
| Project | MariaDB Enterprise [ 11500 ] | MariaDB Server [ 10000 ] |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] |
| Component/s | Information Schema [ 14413 ] | |
| Component/s | Storage Engine - InnoDB [ 10129 ] | |
| Fix Version/s | 10.1.46 [ 24308 ] | |
| Fix Version/s | 10.2.33 [ 24307 ] | |
| Fix Version/s | 10.3.24 [ 24306 ] | |
| Fix Version/s | 10.4.14 [ 24305 ] | |
| Fix Version/s | 10.5.5 [ 24423 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Labels | ServiceNow |
| Labels | ServiceNow | 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z |
| Labels | 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z |
| Workflow | MariaDB v3 [ 110170 ] | MariaDB v4 [ 157979 ] |
| Zendesk Related Tickets | 201658 121075 | |
| Zendesk active tickets | 201658 |