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

[AUDITING] query error due to lack of permissions shows up as a select instead of an unrecognized parameter

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 5.5.0
    • 5.5.0
    • query
    • 5.5.0-2250
    • Untriaged
    • Unknown

    Description

      When I first wrote the auditing tests this query(with no select permissions):

      select * from default limit 100

      [
      {
      "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."
      }
      ]

      Would appear in the log as an unrecognized statement (codeĀ 28687)

      Now however it appears in the log as a select statement, is this a planned change in behavior?

      {"timestamp":"2018-03-21T13:36:10.221-07:00","real_userid":{"source":"local","user":"no_select"},"requestId":"51d78257-9616-47df-8dba-2260daf8cad3","statement":"select * from default limit 100","clientContextId":"b917b8fe-3ba2-4212-b433-e9b29e6a79ac","isAdHoc":true,"userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.162 Safari/537.36 (Couchbase Query Workbench (5.5.0-2255-enterprise))","node":"192.168.10.12:8091","status":"stopped","metrics":{"elapsedTime":"3.437943ms","executionTime":"3.420614ms","resultCount":0,"resultSize":0,"errorCount":1},"id":28672,"name":"SELECT statement","description":"A N1QL SELECT statement was executed"}

      Attachments

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

        Activity

          People

            ajay.bhullar Ajay Bhullar
            ajay.bhullar Ajay Bhullar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty