Correct bug in user delete api calls.

- Make sure that Activation cascade deletes
- Add tests that it behaves as expected.