
UPDATE acm_group_role_menu agrm SET STATUS = 1 WHERE agrm.client_portal_id = 142;
UPDATE acm_group_role_menu agrm SET STATUS = 0 WHERE agrm.client_portal_id = 142 AND menus_id=3;
UPDATE acm_group_role_menu agrm SET STATUS = 0 WHERE agrm.client_portal_id = 142 AND menus_id=7;


/* for access matrix */
UPDATE acm_group_role_menu SET STATUS = 0 WHERE (menus_id  = 344 OR menus_id  = 345 OR menus_id  = 346 OR menus_id  = 347 OR menus_id  = 348 OR menus_id  = 349) ;
/* for pm */
UPDATE acm_group_role_menu SET STATUS = 0 WHERE (menus_id  = 45 OR menus_id  = 46 OR menus_id  = 47 OR menus_id  = 48 OR menus_id  = 49 OR menus_id  = 51 OR menus_id  = 51 OR menus_id  = 388 OR menus_id  = 166 OR menus_id  = 167); 
