Adding in tests for default user roles

Additional tests for default roles when adding users.

One test is in the db functional test because of constraints caused by the init_auth and teardown in the authentication tests.