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

              Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              anel Anel Husakovic
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration