issues: 631931408

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason
631931408 MDU6SXNzdWU2MzE5MzE0MDg= 800 Canned query permissions mechanism 9599 closed 0   5512395 14 2020-06-05T20:28:21Z 2020-06-07T16:22:53Z 2020-06-07T16:22:53Z OWNER  

Idea: default is anyone can execute a query.

Or you can specify the following:

```json

{
"databases": {
"my-database": {
"queries": {
"add_twitter_handle": {
"sql": "insert into twitter_handles (username) values (:username)",
"write": true,
"allow": {
"id": ["simon"],
"role": ["staff"]
}
}
}
}
}
}
`` These get matched against the actor JSON. If any of the fields in any of the keys of"allow"` match a key on the actor, the query is allowed.

"id": "*" matches any actor with an id key.

Originally posted by @simonw in https://github.com/simonw/datasette/issues/698#issuecomment-639784651

107914493 issue  

Links from other tables

Powered by Datasette · Query took 1.823ms · About: github-to-sqlite