Tests that demonstrate table-level permissions

[simonw]

I built this for:

• Support setting permissions at the individual table level #22

But in writing the release notes (#58) I realized the tests don't actually cover this yet. The documentation should mention it too.

[simonw]

I first did a round of manual testing:

sqlite-utils create-database sales.db
sqlite-utils create-database marketing.db
sqlite-utils create-table sales.db notes id integer --pk id
sqlite-utils create-table sales.db customers id integer --pk id
datasette -c perms.yml sales.db marketing.db --secret 1 --reload

Where perms.yml contained:

databases:
  marketing:
    permissions:
      create-table:
        id: pelican
      drop-table:
        id: pelican
      alter-table:
        id: pelican
  sales:
    tables:
      notes:
        permissions:
          alter-table:
            id: pelican

And I used a new datasette-unsafe-actor-debug plugin to help test.

This worked, though it did show me I need to fix this:

• User with limited permissions should not be able to rename a table #60