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

[N1QL RBAC]User with views_admin[default] permission not able to view any indexes in system:indexes

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Minor
    • bug-backlog
    • 5.0.0
    • query
    • 5.0.0-3008
    • Untriaged
    • No

    Description

      Based on the table in the doc:
      https://docs.google.com/document/d/1huT_X-ln-RQ2HxFIaJ7oXmEW4-LR-7od5itffYMgbSk/edit

      The views_admin should be able to view <<my>> indexes in system:indexes table.
      But right now I get this error:

      prernamanaktala@MacBook-Pro testrunner-rqg (master) $ curl -u johnDoe4:password1 http://172.23.107.182:8093/query/service -d 'statement=select * from system:indexes'
      {
      "requestID": "6e907cfd-fd9c-4f3e-8ac3-b392898d7b94",
      "signature": {"*":"*"},
      "results": [
      ],
      "warnings": [{"code":11011,"msg":"One or more documents were excluded from the system:indexes bucket because of insufficient user permissions."}],
      "status": "success",
      "metrics": {"elapsedTime": "145.385903ms","executionTime": "145.330108ms","resultCount": 0,"resultSize": 0,"warningCount": 1}
      }
      

      where johnDoe4 has role: views_admin(default)

      Buckets present in cluster:
      default and standard_bucket0

      Indexes created:
      CREATE PRIMARY INDEX `#primary` ON `default`
      CREATE PRIMARY INDEX `#primary` ON `default`
      CREATE INDEX `idx1` ON `default`(`name`)

      Attachments

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

        Activity

          People

            isha Isha Kandaswamy (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            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