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

[N1QL RBAC] "default": "Navigator Doppelbock" Error message reported when a user with query_insert permission tries to select from a bucket.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 5.0.0
    • 5.0.0
    • query
    • 5.0.0-3136
    • Untriaged
    • Unknown

    Description

      1. create a bucket default with no documents.
      2. create a user test with password as <<password>> with permission as query_insert on bucket default from UI.
      3. Try the following query with login as test/password:
      cbq> [root@localhost bin]# ./cbq -u test -p password
      Connected to : http://localhost:8091/. Type Ctrl-D or \QUIT to exit.
      cbq> select * from default limit 1;
      {
      "requestID": "31d46597-50c7-414f-ac78-2f1bcbc0083c",
      "signature":

      { "*": "*" }

      ,
      "results": [

      { "default": "Navigator Doppelbock" }

      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "31.340212ms", "executionTime": "31.299778ms", "resultCount": 1, "resultSize": 57 }

      }

      We see the above error.

      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