Role Authorization Bug - Inventory Balance

Creation date: 18/10/2022 16:37    Updated: 18/10/2022 16:37   #inventorybalance #roleauthorization
Question:

Please help check this issue.

On Production Env, i think there are some bug views, if you see the video and the picture. all action is checklist but we can't see which module are checklist which module not checklist.

If you see in Staging Env, I already checklist inventory balance for Inventory Team Role, but when i try login with the Inventory Team account, i can't open the the inventory module 

 


Answer:

Investigation:

Missing a query in the inventory balance. Use the script below to insert the query and it works.
/*SQLyog Ultimate v12.08 (64 bit)
MySQL - 5.7.12-log 
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

insert into `BSM_FUNCTION_ACTION` (`organizationId`, `functionId`, `actionId`, `parentActionId`, `actionIndex`, `showSequence`, `activeFlag`, `noteText`, `udf01`, `udf02`, `udf03`, `udf04`, `udf05`, `currentVersion`, `oprSeqFlag`, `addWho`, `addTime`, `editWho`, `editTime`, `allFlag`, `systemFlag`, `jsonData`, `actionCode`, `upLoadFlag`, `udf06`) 
values('OJV_SHIPPER','A2501','QRY','BASIC','0,QRY','12853','Y','','','','','','','103','20211223141149000767RA010128075132[A0530]',
'UDFTIMER','2021-01-29 22:59:39','UDFTIMER','2021-01-29 22:59:39','N','Y',NULL,NULL,'',NULL);

insert into `BSM_FUNCTION_ACTION_ML` (`organizationId`, `functionId`, `actionId`, `actionDescr`, `udfActionDescr`, `languageId`, `noteText`, `udf01`, `udf02`, `udf03`, `udf04`, `udf05`, `udf06`, `currentVersion`, `oprSeqFlag`, `addWho`, `addTime`, `editWho`, `editTime`) 
values('OJV_SHIPPER','A2501','QRY','query',NULL,'en',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'100','2020','UDFTIMER','2021-01-29 22:59:39','UDFTIMER','2021-12-23 14:11:49');
insert into `BSM_FUNCTION_ACTION_ML` (`organizationId`, `functionId`, `actionId`, `actionDescr`, `udfActionDescr`, `languageId`, `noteText`, `udf01`, `udf02`, `udf03`, `udf04`, `udf05`, `udf06`, `currentVersion`, `oprSeqFlag`, `addWho`, `addTime`, `editWho`, `editTime`) 
values('OJV_SHIPPER','A2501','QRY','??',NULL,'zh_CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'100','2020','UDFTIMER','2021-01-29 22:59:39','UDFTIMER','2021-12-23 14:11:49');
insert into `BSM_FUNCTION_ACTION_ML` (`organizationId`, `functionId`, `actionId`, `actionDescr`, `udfActionDescr`, `languageId`, `noteText`, `udf01`, `udf02`, `udf03`, `udf04`, `udf05`, `udf06`, `currentVersion`, `oprSeqFlag`, `addWho`, `addTime`, `editWho`, `editTime`) 
values('OJV_SHIPPER','A2501','QRY','??',NULL,'zh_TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'100','2020','UDFTIMER','2021-01-29 22:59:39','UDFTIMER','2021-12-23 14:11:49');



Investigation:

That the blue box is not indicating that it is allowed. It is partial permission. Only tick is consider full permission.