Details
-
Bug
-
Resolution: Fixed
-
Major
-
5.0.0
-
5.0.0-4505
-
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