ALTER TABLE ranger.x_group MODIFY group_name VARCHAR(191);
ALTER TABLE ranger.x_user MODIFY user_name VARCHAR(191);
ALTER TABLE ranger.x_service MODIFY name VARCHAR(191);
ALTER TABLE ranger.x_portal_user MODIFY login_id VARCHAR(191);
ALTER TABLE ranger.x_portal_user MODIFY email VARCHAR(191);
ALTER TABLE ranger.x_portal_user MODIFY first_name VARCHAR(191);
ALTER TABLE ranger.x_group_users MODIFY group_name VARCHAR(191);
ALTER TABLE ranger.x_resource MODIFY policy_name VARCHAR(191);
ALTER TABLE ranger.x_tag_def MODIFY name VARCHAR(191);
ALTER TABLE ranger.x_plugin_info MODIFY service_name VARCHAR(191);
ALTER TABLE ranger.x_plugin_info MODIFY host_name VARCHAR(191);

ALTER TABLE ranger.x_access_type_def CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_access_type_def_grants CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_asset CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_audit_map CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_auth_sess CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_context_enricher_def CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_cred_store CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_data_hist CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_datamask_type_def CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_db_base CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_db_version_h CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_enum_def CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_enum_element_def CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_group CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_group_groups CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_group_module_perm CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_group_users CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_modules_master CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_perm_map CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_plugin_info CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_policy CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_policy_condition_def CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_policy_export_audit CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_policy_item CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_policy_item_access CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_policy_item_condition CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_policy_item_datamask CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_policy_item_group_perm CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_policy_item_rowfilter CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_policy_item_user_perm CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_policy_resource CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_policy_resource_map CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_portal_user CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_portal_user_role CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_resource CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_resource_def CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_service CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_service_config_def CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_service_config_map CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_service_def CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_service_resource CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_service_resource_element CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_service_resource_element_val CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_service_version_info CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_tag CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_tag_attr CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_tag_attr_def CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_tag_def CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_tag_resource_map CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_trx_log CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_user CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.x_user_module_perm CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE ranger.xa_access_audit CONVERT TO CHARACTER SET utf8mb4;