Delete Query Restriction

Couchbase Server
1

Hi,

I just wonder is it possible to only disable DELETE sql on query page?
It should be something like single query restriction.

Thank you.

2

You can create a new user with the following privileges:

Give them Administrative → Readonly Admin so they can use the console.
Give them Query SELECT privilege so that the Query tab appears in the console. This will also give them Data Reader privilege.

Query Select [travel-sample::] , Data Reader [travel-sample::] , Read-Only Admin

If they attempt to use DELETE (or UPDATE), they will get a message like this:

[
  {
    "code": 13014,
    "msg": "User does not have credentials to run DELETE queries on default:travel-sample._default._default. Add role query_delete on default:travel-sample._default._default to allow the statement to run.",
    "reason": {
      "missing_role": "query_delete",
      "path": "default:travel-sample._default._default"
    },
    "query": "DELETE  from default:`travel-sample`._default._default"
  }
]
1 Like
3

Thank you so much!

It worked.

1 Like