Show Equipments&Workorder for a given location for a user group

snow.lovers

      If you want to only show work orders & equipment for a given location, based upon the user login, this is a way of solving it. Connect to the database using your favorite SQL program(ex. PLSQL Developer) and run these two statements:

update userrestrictions set restrictions= \'(location in (\'\'IDG-CELL\'\',\'\'MXM-CELL\'\'))\' WHERE MODULE = \'WO\' AND APP IN (\'QUICKREP\',\'WOREQ\',\'WOTRACK\') AND USERNAME IN (SELECT USRNAME FROM MAXUSERGROUPS WHERE GRPNAME = \'RFDMFG\')

update userrestrictions set restrictions= \'(location in (\'\'IDG-CELL\'\',\'\'MXM-CELL\'\'))\' WHERE MODULE = \'EQUIPMNT\' AND APP IN (\'EQUIPMNT\') AND USERNAME IN (SELECT USRNAME FROM MAXUSERGROUPS WHERE GRPNAME = \'RFDMFG\')

jeffreyqi

不错，学了。哈哈

hafocus

这个方法只能解决在 select工单的时候不能查看其他位置的数据,但是并不能阻止用户创建一个location=''MXM-CELL'' 的工单,.

snow.lovers

要阻止也不难吧