Route for adding a new user

provided the role requesting addition has insert privileges to `dbapi.auth` and usage privileges for the `dbapi` schema.