Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1835

Wrong permission error on SELECT 1

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.1.6
    • Icebox
    • ?
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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