COBISOFT Documentation

User Tools

Site Tools

You are here: start » COBI.wms » Management Database
cobi.wms:management_database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
cobi.wms:management_database [2025/07/24 08:30] – [Permission management] thuthcobi.wms:management_database [2025/07/24 08:40] (current) – [Permission management] thuth
Line 297: Line 297:
   * ''WTQ'': Inventory transfer request   * ''WTQ'': Inventory transfer request
   * ''PRINT'': Label printing   * ''PRINT'': Label printing
 +  * ''ITEM'': Item info
  
 For your convenience, here is a template for calling the ''setUserPermission'' procedure once for every module, which you can copy & paste into SQL Server Management Studio or HANA Studio: For your convenience, here is a template for calling the ''setUserPermission'' procedure once for every module, which you can copy & paste into SQL Server Management Studio or HANA Studio:
Line 319: Line 320:
 exec setUserPermission 'username', 'WTQ', 1; exec setUserPermission 'username', 'WTQ', 1;
 exec setUserPermission 'username', 'PRINT', 1; exec setUserPermission 'username', 'PRINT', 1;
 +exec setUserPermission 'username', 'ITEM', 1;
  
 -- SAP HANA -- SAP HANA
Line 338: Line 340:
 call setUserPermission('username', 'WTQ', 1); call setUserPermission('username', 'WTQ', 1);
 call setUserPermission('username', 'PRINT', 1); call setUserPermission('username', 'PRINT', 1);
 +call setUserPermission('username', 'ITEM', 1);
 </code> </code>
  
Line 363: Line 366:
 exec setDevicePermission deviceID, 'WTQ', 1; exec setDevicePermission deviceID, 'WTQ', 1;
 exec setDevicePermission deviceID, 'PRINT', 1; exec setDevicePermission deviceID, 'PRINT', 1;
 +exec setDevicePermission deviceID, 'ITEM', 1;
  
 -- SAP HANA -- SAP HANA
Line 382: Line 386:
 call setDevicePermission(deviceID, 'WTQ', 1); call setDevicePermission(deviceID, 'WTQ', 1);
 call setDevicePermission(deviceID, 'PRINT', 1); call setDevicePermission(deviceID, 'PRINT', 1);
 +call setDevicePermission(deviceID, 'ITEM', 1);
 </code> </code>
  
 Change ''deviceID'' to the correct device ID number via search & replace, and switch the 1 at the end to a 0 for the modules to disable. Change ''deviceID'' to the correct device ID number via search & replace, and switch the 1 at the end to a 0 for the modules to disable.
cobi.wms/management_database.txt · Last modified: 2025/07/24 08:40 by thuth
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki