Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25300

Connect - anonymous user can create table but cannot replace

    XMLWordPrintable

Details

    Description

      MariaDB [test]> select current_user;
      +--------------+
      | current_user |
      +--------------+
      | @localhost   |
      +--------------+
      MariaDB [test]> create or replace table t1 engine=connect table_type=JSON file_name='users.json' http='http://jsonplaceholder.typicode.com' uri='users' option_list='curl=0';
      Query OK, 0 rows affected (0.19 sec)
      MariaDB [test]> create or replace table t1 engine=connect table_type=JSON file_name='users.json' http='http://jsonplaceholder.typicode.com' uri='users' option_list='curl=0';
      ERROR 1227 (42000): Access denied; you need (at least one of) the FILE privilege(s) for this operation
      

      Attachments

        Issue Links

          Activity

            People

              bertrandop Olivier Bertrand
              anel Anel Husakovic
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.