-- 2016-02-10 special read-only user for Digital Stage ds_user J827bHWNYyqQu9nM -- 販売前 GRANT SELECT ON `itojuku_test2`.`koza_code_master` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`master_kanri` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`koza` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`curriculum` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`curriculum_hassocode` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`hassobi` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`hassocode` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`hassocode_hassobi` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`hassocode_buppin` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`event_koza` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`smsevent` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`sms_event_instance` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `buppin_name`, `buppin_category`, `buppin_code`, `shikenshu`, `kaikonen`, `buppin_code_7`, `seishikimeisho`, `shuppansha`, `hanbai_tanka`, `teika`, `fair_tanka`, `shainwari_tanka`, `version_up_tanka`, `rejiyou_barcode`, `idouheikin_tanka`, `haiki_umu`, `if_code_buppin`, `shohin_kobestu_number_buppin`, `buppin_form` ) ON `itojuku_test2`.`buppin` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `school_id`, `name`, `category` ) ON `itojuku_test2`.`resource` TO 'ds_user'@'%'; GRANT SELECT ( `id_sub1`, `tel_c`, `address_c`, `fax_c`, `school_code`, `eshop_code`, `eshop_jukoukeitai_01d` ) ON `itojuku_test2`.`resource_sub1` TO 'ds_user'@'%'; -- 販売後 GRANT SELECT ON `itojuku_test2`.`koza_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`event_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`hasso_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`hassocode_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`smsevent_instances` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`sms_event_instance_sub` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`sms_memo` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`shukka_kobetsu` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`shiken` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`shiken_student` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `alt_address_city`, `alt_address_postalcode`, `alt_address_state`, `alt_address_street`, `birthdate`, `email_opt_out`, `email1`, `email2`, `first_name`, `first_name_furigana`, `gender`, `grade`, `houka_graduate_school`, `idnumber`, `smsgroup`, `contact_status`, `jikanshitei`, `kiseisaki_address_city`, `kiseisaki_address_postalcode`, `kiseisaki_address_state`, `kiseisaki_address_street`, `kiseisaki_date_end`, `kiseisaki_date_entered`, `kiseisaki_phone`, `kiseisaki_phone_cleaned`, `kishu_mishu`, `kyokudome_address_city`, `kyokudome_address_kana`, `kyokudome_address_postalcode`, `kyokudome_address_state`, `kyokudome_address_street`, `last_name`, `last_name_furigana`, `phone_home`, `phone_home_cleaned`, `phone_mobile`, `phone_mobile_cleaned`, `primary_address_city`, `primary_address_postalcode`, `primary_address_state`, `primary_address_street`, `university`, `urgency_name`, `urgency_phone`, `urgency_phone_cleaned` ) ON `itojuku_test2`.`contacts` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `school_id`, `name`, `event_id`, `contact_id`, `type_id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `sell_date`, `basic_fee`, `description`, `applied_contact`, `salesno`, `start_date`, `product_id`, `nyukin_zumi`, `uriagekubun`, `suryo`, `hasso_from_soko`, `koza_id`, `buppin_id`, `uriage_keitai`, `buppin_tanka`, `waribiki_category`, `buppin_category`, `schedule_sakusei_flg`, `kaiyaku_flg` ) ON `itojuku_test2`.`sms_fee` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `fee_id`, `type_id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `sell_date`, `due_date`, `t_date`, `in_amount`, `actual_in_amount`, `contact_id`, `event_id`, `payment_type`, `description`, `salesno`, `fee_name`, `school_id`, `koza_id`, `buppin_id`, `nyuukinsaki_kouza`, `nyuukinsaki_card_credit`, `nyuukinsaki_shori_number`, `seikyou_dairiten_id`, `dairiten_uketsukebi`, `hanbaikeiro`, `waribiki_category`, `buppin_category`, `uriagekubun`, `debit_card` ) ON `itojuku_test2`.`sms_transaction` TO 'ds_user'@'%'; -- 販売前 GRANT SELECT ON `itojuku_test`.`koza_code_master` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`master_kanri` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`koza` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`curriculum` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`curriculum_hassocode` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`hassobi` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`hassocode` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`hassocode_hassobi` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`hassocode_buppin` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`event_koza` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`smsevent` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`sms_event_instance` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `buppin_name`, `buppin_category`, `buppin_code`, `shikenshu`, `kaikonen`, `buppin_code_7`, `seishikimeisho`, `shuppansha`, `hanbai_tanka`, `teika`, `fair_tanka`, `shainwari_tanka`, `version_up_tanka`, `rejiyou_barcode`, `idouheikin_tanka`, `haiki_umu`, `if_code_buppin`, `shohin_kobestu_number_buppin`, `buppin_form` ) ON `itojuku_test`.`buppin` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `school_id`, `name`, `category` ) ON `itojuku_test`.`resource` TO 'ds_user'@'%'; GRANT SELECT ( `id_sub1`, `tel_c`, `address_c`, `fax_c`, `school_code`, `eshop_code`, `eshop_jukoukeitai_01d` ) ON `itojuku_test`.`resource_sub1` TO 'ds_user'@'%'; -- 販売後 GRANT SELECT ON `itojuku_test`.`koza_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`event_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`hasso_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`hassocode_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`smsevent_instances` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`sms_event_instance_sub` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`sms_memo` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`shukka_kobetsu` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`shiken` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`shiken_student` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `alt_address_city`, `alt_address_postalcode`, `alt_address_state`, `alt_address_street`, `birthdate`, `email_opt_out`, `email1`, `email2`, `first_name`, `first_name_furigana`, `gender`, `grade`, `houka_graduate_school`, `idnumber`, `smsgroup`, `contact_status`, `jikanshitei`, `kiseisaki_address_city`, `kiseisaki_address_postalcode`, `kiseisaki_address_state`, `kiseisaki_address_street`, `kiseisaki_date_end`, `kiseisaki_date_entered`, `kiseisaki_phone`, `kiseisaki_phone_cleaned`, `kishu_mishu`, `kyokudome_address_city`, `kyokudome_address_kana`, `kyokudome_address_postalcode`, `kyokudome_address_state`, `kyokudome_address_street`, `last_name`, `last_name_furigana`, `phone_home`, `phone_home_cleaned`, `phone_mobile`, `phone_mobile_cleaned`, `primary_address_city`, `primary_address_postalcode`, `primary_address_state`, `primary_address_street`, `university`, `urgency_name`, `urgency_phone`, `urgency_phone_cleaned` ) ON `itojuku_test`.`contacts` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `school_id`, `name`, `event_id`, `contact_id`, `type_id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `sell_date`, `basic_fee`, `description`, `applied_contact`, `salesno`, `start_date`, `product_id`, `nyukin_zumi`, `uriagekubun`, `suryo`, `hasso_from_soko`, `koza_id`, `buppin_id`, `uriage_keitai`, `buppin_tanka`, `waribiki_category`, `buppin_category`, `schedule_sakusei_flg`, `kaiyaku_flg` ) ON `itojuku_test`.`sms_fee` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `fee_id`, `type_id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `sell_date`, `due_date`, `t_date`, `in_amount`, `actual_in_amount`, `contact_id`, `event_id`, `payment_type`, `description`, `salesno`, `fee_name`, `school_id`, `koza_id`, `buppin_id`, `nyuukinsaki_kouza`, `nyuukinsaki_card_credit`, `nyuukinsaki_shori_number`, `seikyou_dairiten_id`, `dairiten_uketsukebi`, `hanbaikeiro`, `waribiki_category`, `buppin_category`, `uriagekubun`, `debit_card` ) ON `itojuku_test`.`sms_transaction` TO 'ds_user'@'%'; -- 2016-08-08 GRANT SELECT ( `contact_status` ) ON `itojuku_test2`.`contacts` TO 'ds_user'@'%'; GRANT SELECT ( `contact_status` ) ON `itojuku_test`.`contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`sms_event_instance_sub` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`sms_event_instance_sub` TO 'ds_user'@'%'; -- 2016-08-11 GRANT SELECT ON `itojuku_test`.`shiken` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test`.`shiken_student` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`shiken` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`shiken_student` TO 'ds_user'@'%'; -- 2016-08-26 本番 priviledge GRANT SELECT ON `itojuku`.`koza_code_master` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`master_kanri` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`koza` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`curriculum` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`curriculum_hassocode` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`hassobi` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`hassocode` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`hassocode_hassobi` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`hassocode_buppin` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`event_koza` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`smsevent` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`sms_event_instance` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `buppin_name`, `buppin_category`, `buppin_code`, `shikenshu`, `kaikonen`, `buppin_code_7`, `seishikimeisho`, `shuppansha`, `hanbai_tanka`, `teika`, `fair_tanka`, `shainwari_tanka`, `version_up_tanka`, `rejiyou_barcode`, `idouheikin_tanka`, `haiki_umu`, `if_code_buppin`, `shohin_kobestu_number_buppin`, `buppin_form` ) ON `itojuku`.`buppin` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `school_id`, `name`, `category` ) ON `itojuku`.`resource` TO 'ds_user'@'%'; GRANT SELECT ( `id_sub1`, `tel_c`, `address_c`, `fax_c`, `school_code`, `eshop_code`, `eshop_jukoukeitai_01d` ) ON `itojuku`.`resource_sub1` TO 'ds_user'@'%'; -- 販売後 GRANT SELECT ON `itojuku`.`koza_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`event_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`hasso_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`hassocode_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`smsevent_instances` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`sms_event_instance_sub` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`sms_memo` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`shukka_kobetsu` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`shiken` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`shiken_student` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `alt_address_city`, `alt_address_postalcode`, `alt_address_state`, `alt_address_street`, `birthdate`, `email_opt_out`, `email1`, `email2`, `first_name`, `first_name_furigana`, `gender`, `grade`, `houka_graduate_school`, `idnumber`, `smsgroup`, `contact_status`, `jikanshitei`, `kiseisaki_address_city`, `kiseisaki_address_postalcode`, `kiseisaki_address_state`, `kiseisaki_address_street`, `kiseisaki_date_end`, `kiseisaki_date_entered`, `kiseisaki_phone`, `kiseisaki_phone_cleaned`, `kishu_mishu`, `kyokudome_address_city`, `kyokudome_address_kana`, `kyokudome_address_postalcode`, `kyokudome_address_state`, `kyokudome_address_street`, `last_name`, `last_name_furigana`, `phone_home`, `phone_home_cleaned`, `phone_mobile`, `phone_mobile_cleaned`, `primary_address_city`, `primary_address_postalcode`, `primary_address_state`, `primary_address_street`, `university`, `urgency_name`, `urgency_phone`, `urgency_phone_cleaned` ) ON `itojuku`.`contacts` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `school_id`, `name`, `event_id`, `contact_id`, `type_id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `sell_date`, `basic_fee`, `description`, `applied_contact`, `salesno`, `start_date`, `product_id`, `nyukin_zumi`, `uriagekubun`, `suryo`, `hasso_from_soko`, `koza_id`, `buppin_id`, `uriage_keitai`, `buppin_tanka`, `waribiki_category`, `buppin_category`, `schedule_sakusei_flg`, `kaiyaku_flg` ) ON `itojuku`.`sms_fee` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `fee_id`, `type_id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `sell_date`, `due_date`, `t_date`, `in_amount`, `actual_in_amount`, `contact_id`, `event_id`, `payment_type`, `description`, `salesno`, `fee_name`, `school_id`, `koza_id`, `buppin_id`, `nyuukinsaki_kouza`, `nyuukinsaki_card_credit`, `nyuukinsaki_shori_number`, `seikyou_dairiten_id`, `dairiten_uketsukebi`, `hanbaikeiro`, `waribiki_category`, `buppin_category`, `uriagekubun`, `debit_card` ) ON `itojuku`.`sms_transaction` TO 'ds_user'@'%'; -- 2016-10-13 training priviledge GRANT SELECT ON `itojuku_training`.`koza_code_master` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`master_kanri` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`koza` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`curriculum` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`curriculum_hassocode` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`hassobi` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`hassocode` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`hassocode_hassobi` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`hassocode_buppin` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`event_koza` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`smsevent` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`sms_event_instance` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `buppin_name`, `buppin_category`, `buppin_code`, `shikenshu`, `kaikonen`, `buppin_code_7`, `seishikimeisho`, `shuppansha`, `hanbai_tanka`, `teika`, `fair_tanka`, `shainwari_tanka`, `version_up_tanka`, `rejiyou_barcode`, `idouheikin_tanka`, `haiki_umu`, `if_code_buppin`, `shohin_kobestu_number_buppin`, `buppin_form` ) ON `itojuku_training`.`buppin` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `school_id`, `name`, `category` ) ON `itojuku_training`.`resource` TO 'ds_user'@'%'; GRANT SELECT ( `id_sub1`, `tel_c`, `address_c`, `fax_c`, `school_code`, `eshop_code`, `eshop_jukoukeitai_01d` ) ON `itojuku_training`.`resource_sub1` TO 'ds_user'@'%'; -- 販売後 GRANT SELECT ON `itojuku_training`.`koza_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`event_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`hasso_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`hassocode_contacts` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`smsevent_instances` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`sms_event_instance_sub` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`sms_memo` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`shukka_kobetsu` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`shiken` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`shiken_student` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `alt_address_city`, `alt_address_postalcode`, `alt_address_state`, `alt_address_street`, `birthdate`, `email_opt_out`, `email1`, `email2`, `first_name`, `first_name_furigana`, `gender`, `grade`, `houka_graduate_school`, `idnumber`, `smsgroup`, `contact_status`, `jikanshitei`, `kiseisaki_address_city`, `kiseisaki_address_postalcode`, `kiseisaki_address_state`, `kiseisaki_address_street`, `kiseisaki_date_end`, `kiseisaki_date_entered`, `kiseisaki_phone`, `kiseisaki_phone_cleaned`, `kishu_mishu`, `kyokudome_address_city`, `kyokudome_address_kana`, `kyokudome_address_postalcode`, `kyokudome_address_state`, `kyokudome_address_street`, `last_name`, `last_name_furigana`, `phone_home`, `phone_home_cleaned`, `phone_mobile`, `phone_mobile_cleaned`, `primary_address_city`, `primary_address_postalcode`, `primary_address_state`, `primary_address_street`, `university`, `urgency_name`, `urgency_phone`, `urgency_phone_cleaned` ) ON `itojuku_training`.`contacts` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `school_id`, `name`, `event_id`, `contact_id`, `type_id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `sell_date`, `basic_fee`, `description`, `applied_contact`, `salesno`, `start_date`, `product_id`, `nyukin_zumi`, `uriagekubun`, `suryo`, `hasso_from_soko`, `koza_id`, `buppin_id`, `uriage_keitai`, `buppin_tanka`, `waribiki_category`, `buppin_category`, `schedule_sakusei_flg`, `kaiyaku_flg` ) ON `itojuku_training`.`sms_fee` TO 'ds_user'@'%'; GRANT SELECT ( `id`, `fee_id`, `type_id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `sell_date`, `due_date`, `t_date`, `in_amount`, `actual_in_amount`, `contact_id`, `event_id`, `payment_type`, `description`, `salesno`, `fee_name`, `school_id`, `koza_id`, `buppin_id`, `nyuukinsaki_kouza`, `nyuukinsaki_card_credit`, `nyuukinsaki_shori_number`, `seikyou_dairiten_id`, `dairiten_uketsukebi`, `hanbaikeiro`, `waribiki_category`, `buppin_category`, `uriagekubun`, `debit_card` ) ON `itojuku_training`.`sms_transaction` TO 'ds_user'@'%'; -- 20161027 shimoju GRANT SELECT ( work_school,kyokudome,work_school_etc,name_work,address_work,phone_work,phone_work_cleaned,email_work,obog_members,primary_address_kana, kiseisaki_address_kana,graduate_school,vocational,gakubu,gakka,hougakukei_circle,circle_title,highschool ) ON `itojuku_training`.`contacts` TO 'ds_user'@'%'; -- 2017-03-07 GRANT SELECT ON `itojuku_test`.`shiken_curriculum` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`shiken_curriculum` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`shiken_curriculum` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`shiken_curriculum` TO 'ds_user'@'%'; -- 2017-03-31 shimoju GRANT SELECT ON `itojuku_test`.`mk_calculation` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`mk_calculation` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`mk_calculation` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`mk_calculation` TO 'ds_user'@'%'; -- 2017-03-31 shimoju GRANT SELECT ON `itojuku_training`.`marksheet` TO 'ds_user'@'%'; -- 2017-04-25 shimoju GRANT SELECT (id,actual_event_start,deleted) ON itojuku_test.sms_recurrence TO 'ds_user'@'%'; GRANT SELECT (id,actual_event_start,deleted) ON itojuku_test2.sms_recurrence TO 'ds_user'@'%'; GRANT SELECT (id,actual_event_start,deleted) ON itojuku_training.sms_recurrence TO 'ds_user'@'%'; GRANT SELECT (id,actual_event_start,deleted) ON itojuku.sms_recurrence TO 'ds_user'@'%'; -- 2017-05-15 shimoju GRANT SELECT ON `itojuku_test`.`marksheet` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`marksheet` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`marksheet` TO 'ds_user'@'%'; -- 2017-05-15 shimoju GRANT SELECT ON `itojuku_test`.`wt_calculation` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_test2`.`wt_calculation` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training`.`wt_calculation` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku_training2`.`wt_calculation` TO 'ds_user'@'%'; GRANT SELECT ON `itojuku`.`wt_calculation` TO 'ds_user'@'%';