grab the type of user from sp_roles table, not deprecated user_type field.