[MDEV-28548] ER_TABLEACCESS_DENIED_ERROR is missing information about DB - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Fix Version/s: 10.3.37, 10.4.27, 10.5.18, 10.6.11, 10.7.7, 10.8.6, 10.9.4, 10.10.2, 10.11.1
Component/s: Server
Labels:
None

connect  con1,localhost,foo,,db1;

show grants;

Grants for foo@localhost

GRANT USAGE ON *.* TO `foo`@`localhost`

GRANT CREATE ON `db1`.* TO `foo`@`localhost`

GRANT CREATE ON `db2`.* TO `foo`@`localhost`

create table t(t int);

show columns in t;

ERROR 42000: SELECT command denied to user 'foo'@'localhost' for table 't'

Database should be shown too:

ERROR 42000: SELECT command denied to user 'foo'@'localhost' for table 'db1.t'

relates to

MDEV-28455 CREATE TEMPORARY TABLES privilege is insufficient for SHOW COLUMNS

links to

PR 2192

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