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
Next revision		Previous revision
cobi.wms:management_database [2025/07/24 08:30] – [Permission management] thuthcobi.wms:management_database [2025/09/18 10:16] (current) – [Importing licenses] thuth
Line 212: Line 212:
  
 <code sql> <code sql>
-insert into licenses (license, 'notes') values ('LICENSE_1', 'WMS'); +insert into licenses (license, notes) values ('LICENSE_1', 'WMS'); 
-insert into licenses (license, 'notes') values ('LICENSE_2', 'PPC'); +insert into licenses (license, notes) values ('LICENSE_2', 'PPC'); 
-insert into licenses (license, 'notes') values ('LICENSE_3', 'PPC, valid until November 2023');+insert into licenses (license, notes) values ('LICENSE_3', 'PPC, valid until November 2023');
 </code> </code>
  
Line 292: Line 292:
   * ''IPN'': Receipt from production   * ''IPN'': Receipt from production
   * ''PRQ'': Purchase request   * ''PRQ'': Purchase request
-  * ''POR'': Purchase order+  * ''POR'': Purchase Order
   * ''ITM'': Wares list   * ''ITM'': Wares list
   * ''INC'': Inventory counting   * ''INC'': Inventory counting
   * ''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.1753338652.txt.gz · Last modified: by thuth
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki