Improve user permissions

[tahpot]

At the moment, database permissions are specified as read, write with one of three options; owner, user, public.

owner should be deprecated and instead it should just be user or public.

Permissions should be updated to support read, write, delete.

[tahpot]

Delete users is supported within the permission setting, but it's not exposed via the permissions configuration.