CREATE USER abc_shop_sec_user@localhost IDENTIFIED BY 'adt1234sqi' ;

GRANT SELECT, INSERT, UPDATE, DELETE, create temporary tables, LOCK TABLES ON abc_shop_dev.* to 'abc_shop_sec_user'@'localhost' ;

show grants for abc_shop_sec_user@localhost ;

rem select from adt_gt_prd.fcm_info only

rem XXX GRANT SELECT ON adt_gt_prd.fcm_info to 'abc_shop_sec_user'@'%' IDENTIFIED BY 'adt1234sqi' ;
GRANT SELECT ON adt_gt_prd.fcm_info to 'abc_shop_sec_user'@'localhost' ;

rem XXX GRANT INSERT ON adt_gt_prd.fcm_sent_msg_info to abc_shop_sec_user ;
GRANT INSERT ON adt_gt_prd.fcm_sent_msg_info to abc_shop_sec_user@'localhost' ;


