core(user): add delete own user data for non-admin user

Created by: Flabelatus

Added handler func, route and new constraints in the user model. This would allow non-admin users to delete their account if they want.