Description
1. create a user with role admin named: 123#$
2. create a user with role Query System Catalog named johnDoe8.
3. Try granting new role to johnDoe9 as:
curl -u 123$#:password http://172.23.98.114:8093/query/service -d 'statement=GRANT query_select on default to johnDoe8' |
{
|
"requestID": "b866739a-d085-4c43-8a41-bc42e314ead4", |
"signature": null, |
"results": [ |
],
|
"errors": [{"code":13014,"msg":"User does not have credentials to access privilege cluster.admin!write. Add role Admin to allow the query to run."}], |
"status": "stopped", |
"metrics": {"elapsedTime": "4.483096ms","executionTime": "4.448118ms","resultCount": 0,"resultSize": 0,"errorCount": 1} |
}
|
123$# already has admin role.