It seems like it’s impossible with community edition to get advanced roles about a user/admin.
When I create a new user, I only got Admin, ReadOnly Admin and Bucket roles checkbox. So when I try to query with n1ql with the rest api, I can’t because I don’t have required permissions given by Query Roles -> Query Select checkbox.
I wonder why, it seems weird because n1ql queries looks like a basic functionnality on couchbase.
First of all, thank you for your product feedback!
With every release of Couchbase, we continue to delight our customers with new features, but also extend the Enterprise functionality of our products.
The behavior you are seeing is as designed, and detailed RBAC roles are only available in the EE edition.
That being said, compared to the previous versions of CE, in 5.0 CE, you can create multiple Couchbase user accounts (which is new), and add them to one of the Roles (Admin, ReadOnly Admin, and Bucket Full Admin). The Bucket Full Admin role was created to give the same effect as bucket passwords from the previous release (ie. full access to the documents inside the bucket).
Hope this helps, and we hope to see you upgrade to the EE version of Couchbase (contact : firstname.lastname@example.org) to get the full RBAC functionality.