[MCOL-1835] Wrong permission error on SELECT 1 Created: 2018-10-29  Updated: 2018-10-29  Resolved: 2018-10-29

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 1.1.6
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: markus makela Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

MariaDB [(none)]> select 1;
ERROR 1044 (42000): Access denied for user 'maxuser'@'%' to database 'infinidb_vtable'
MariaDB [(none)]> show grants;
+--------------------------------------------------------------------------------------------------------+
| Grants for maxuser@%                                                                                   |
+--------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'maxuser'@'%' IDENTIFIED BY PASSWORD '*5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0' |
| GRANT SELECT ON `infinidb_vtable`.* TO 'maxuser'@'%'                                                   |
+--------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

granting GRANT CREATE TEMPORARY TABLES ON infinidb_vtable.* TO maxuser; solves it.



 Comments   
Comment by markus makela [ 2018-10-29 ]

This is expected behavior and is documented here: https://mariadb.com/kb/en/library/columnstore-database-user-management/#basic-user-management

Generated at Thu Feb 08 02:31:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.