[MDEV-30056] Impossible to export column grants - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Fix Version/s: 10.3.38, 10.4.28, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3
Component/s: Authentication and Privilege System
Labels:
None
Environment:
Debian 11

Description

when we want export role from MariaDB, and when it use 'reserved key word' it's not possible to import these roles :

example :

mysql --skip-column-names --no-auto-rehash --silent --execute="SELECT CONCAT('SHOW GRANTS FOR ''',User,''';') FROM mysql.user WHERE is_role = 'Y'" | mysql --skip-column-names --no-auto-rehash | sed 's/$/;/g;1s/^/## Grants for Roles ##\n/' > /tmp/role-grants.sql

GRANT SELECT (segmentation, cms, order, idAccount, runRateAmount, sector) ON `pc_common_copy`.`accountsSalesForceData` TO 'role_devro01';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order, idAccount, runRateAmount, sector) ON `pc_common_copy`.`accountsSalesForce' at line 1

Here the problem with ORDER but it's the same with other keysword.

The goal there, should be to encapsulate fields with back quotes.

GRANT SELECT (segmentation, cms, `order`, idAccount, runRateAmount, sector) ON `pc_common_copy`.`accountsSalesForceData` TO 'role_devro01';

Attachments

Activity

There are no comments yet on this issue.

People

Assignee:: Sergei Golubchik

Reporter:: Aurélien LEQUOY

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2022-11-21 10:41

Updated:: 2022-12-02 18:51

Resolved:: 2022-12-02 18:51

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server