**Describe the solution you'd like**

An option to make the `IDENTIFIED WITH` section mandatory.

User & user,
        const ASTCreateUserQuery & query,
        const std::shared_ptr<ASTUserNameWithHost> & override_name,
        const std::optional<RolesOrUsersSet> & override_default_roles,
        const std::optional<SettingsProfileElements> & override_settings,
        const std::optional<RolesOrUsersSet> & override_grantees,
        bool allow_no_password,
        bool allow_plaintext_password)
    {
        if (override_name)
            user.setName(override_name->toString());
        else if (query.new_name)
            user.setName(*query.new_name);
        else if (query.names->size() == 1)
            user.setName(query.names->front()->toString());
        if (query.auth_data)
            user.auth_data = *query.auth_data;
        if (query.auth_data || !query.alter)
        {
            auto auth_type = user.auth_data.getType();