issue_comments: 1334666806

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/datasette/issues/1636#issuecomment-1334666806 https://api.github.com/repos/simonw/datasette/issues/1636 1334666806 IC_kwDOBm6k_c5PjWY2 9599 2022-12-02T01:58:40Z 2022-12-02T02:00:53Z OWNER

Current design:

json { "databases": { "private": { "allow": { "id": "*" } } } } This can be applied at the instance, database, table or query level within the nested JSON.

https://docs.datasette.io/en/stable/authentication.html#controlling-access-to-specific-databases

It's actually controlling the following permissions:

  • view-instance
  • view-database
  • view-table
  • view-query

There's also a special case for allowing SQL queries,at the instance and database level:

json { "databases": { "mydatabase": { "allow_sql": { "id": "root" } } } }

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1138008042