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

User with query-update permission on bucket can't update bucket with collection format

    XMLWordPrintable

Details

    • Untriaged
    • Centos 64-bit
    • No

    Description

      I've created a user "test" with "Query Update[beer-sample], Query Select[beer-sample]" permission on beer-sample bucket. When I'm running below query I'm getting 401.

       

      UPDATE default:`beer-sample`._default._default SET META().expiration = 2
       
      [
        {
          "code": 13014,
          "msg": "User does not have credentials to run UPDATE queries on the beer-sample._default._default bucket. Add role query_update on beer-sample._default._default to allow the query to run."
        }
      ]
       
      
      

       

      However, I'm able to run query with below formats - 

      UPDATE `beer-sample` SET META().expiration = 0 - OK
      UPDATE default:`beer-sample` SET META().expiration = 0 - OK
      

      Steps To reproduce - 

      1. load beer-sample
      2. create a user "test" with query-select and query-update permission
      3. Login as test user and run this query - "UPDATE default:`beer-sample`._default._default SET META().expiration = 2"

       

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              hemant.rajput Hemant Rajput
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty