From: Vladimir Davydov <vdavydov.dev@gmail.com> To: Kirill Yukhin <kyukhin@tarantool.org> Cc: tarantool-patches@freelists.org Subject: Re: [PATCH v2 4/4] sql: check read access while executing SQL query Date: Sat, 27 Oct 2018 00:04:00 +0300 [thread overview] Message-ID: <20181026210400.renemmhvwhqnghqt@esperanza> (raw) In-Reply-To: <4190713e5ce5192e75456defc9d0a904ce422aff.1540388902.git.kyukhin@tarantool.org> On Thu, Oct 25, 2018 at 11:17:12AM +0300, Kirill Yukhin wrote: > Since SQL front-end is not using box API, > no checkes for read access are performed by VDBE engine. > Add check to IteratorOpen op-code to make sure that read > privilege exists for given space. > Note, that there's is no need to perform DML/DDL checkes as > they're performed by Tarantool's core. > > @TarantoolBot document > Title: Document behaviour of SQL in presence of > read access restrictions. Need to clarify, that This line is like 50 characters long. Why? The limit for commit messages is 72. Doesn't emacs now that? Vim does. > if there's no read access to the space, then not > only SELECT statements will fail, but also those DML > which implies reading from spaces indirectly, e.g.: > UPDATE t1 SET a=2 WHERE b=3; > > Closes #2362 > --- > src/box/sql/vdbe.c | 5 ++ > test/sql/gh-2362-select-access-rights.result | 110 +++++++++++++++++++++++++ > test/sql/gh-2362-select-access-rights.test.lua | 42 ++++++++++ > 3 files changed, 157 insertions(+) > create mode 100644 test/sql/gh-2362-select-access-rights.result > create mode 100644 test/sql/gh-2362-select-access-rights.test.lua Pushed to 2.1
prev parent reply other threads:[~2018-10-26 21:04 UTC|newest] Thread overview: 12+ messages / expand[flat|nested] mbox.gz Atom feed top 2018-10-25 8:17 [PATCH v2 0/4] Check " Kirill Yukhin 2018-10-25 8:17 ` [PATCH v2 1/4] schema: refactor space_cache API Kirill Yukhin 2018-10-25 14:48 ` Vladimir Davydov 2018-10-25 15:31 ` Kirill Yukhin 2018-10-25 16:09 ` Vladimir Davydov 2018-10-25 8:17 ` [PATCH v2 2/4] schema: add space names cache Kirill Yukhin 2018-10-26 20:55 ` Vladimir Davydov 2018-11-01 11:34 ` [tarantool-patches] " Konstantin Osipov 2018-10-25 8:17 ` [PATCH v2 3/4] sql: use space_by_name in SQL Kirill Yukhin 2018-10-26 21:00 ` Vladimir Davydov 2018-10-25 8:17 ` [PATCH v2 4/4] sql: check read access while executing SQL query Kirill Yukhin 2018-10-26 21:04 ` Vladimir Davydov [this message]
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=20181026210400.renemmhvwhqnghqt@esperanza \ --to=vdavydov.dev@gmail.com \ --cc=kyukhin@tarantool.org \ --cc=tarantool-patches@freelists.org \ --subject='Re: [PATCH v2 4/4] sql: check read access while executing SQL query' \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox