Mark UsersResourceService non-transactional

That way it doesn't rollback the transaction when
NoSuchResourceException is found, even if using a version of core-db
where NoSuchResourceException is an unchecked exception.