Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-25510

[NIQL RBAC]Upsert not allowed by a user having permissions query_update and query_insert

    XMLWordPrintable

Details

    • Untriaged
    • No

    Description

      1. create a user with role as query_update and query_insert on a bucket.
      2. Try the following upsert command:

       curl -u johnDoe:password1 http://172.23.107.182:8093/query/service -d 'statement=UPSERT INTO default (KEY, VALUE) VALUES("1", { "value1": "one1" }) RETURNING *'
      {
      "requestID": "12e3c3a0-175f-4cc8-9e1f-2eb6ece0a96a",
      "signature": {"*":"*"},
      "results": [
      ],
      "errors": [{"code":13014,"msg":"User does not have credentials to run SELECT queries on the default bucket. Add role query_select on default to allow the query to run."}],
      "status": "stopped",
      "metrics": {"elapsedTime": "7.691897ms","executionTime": "7.566431ms","resultCount": 0,"resultSize": 0,"errorCount": 1}
      }
      

      3. Above scenario is in sync with the edited permission matrix:
      https://docs.google.com/spreadsheets/d/1f-wR5KBlBEkuTzOVHOhSaUCpMPyEvZ63PKer-TnWOMw/edit?ts=597a7a02#gid=0

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty