meta data for this page
This is an old revision of the document!
JDEUTIL
Apply to your VIGILENS requests the security of your JDE user
Presentation
The optional JDEUtil module allows you to improve the integration of Vigilens with JDE EnterpriseOne, by dynamically retrieving in Vigilens, at runtime from JDE/E1 :
- The security of your JDE user
- The connected JDE user
- The JDE connection environment
Case Study
JDE security
user CO_ALL
Now, the user CO_ALL connects to JDE and clicks on a Vigilens link:
The user does not reconnect in VIGILENS, nor does he use a generic user
The user CO_ALL has no restriction in JDE, the execution of the query displays the result for all the companies.
user CO_00070
The user CO_00070 connects to JDE and clicks on a Vigilens link:
The user does not reconnect in VIGILENS, nor does he use a generic user
The user CO_00070 only has access to the company 00070, VIGILENS adds this restriction automatically when the request is executed,
Operating principle
JDEUTIL is a JD Edwards application specifically developed by VIGILENS (P59VLVIG) to apply the line security of the connected JDE user to queries executed from JD Edwards web.
- The user launches a VIGILENS query from JDE
- Creation of a record in the F59VGSEC table. This record is used to create an anonymous and ephemeral authorization to connect to VIGILENS
- Vigilens Designer: The Vigilens user manages the authorization to access the requests
- Vigilens Web displays the result
The URL used is hidden and ephemeral
The identifier passed to VIGILENS is a unique key generated by JDEUTIL (P59VLVIG). The identifier is therefore anonymous
VIGILENS will then delete the record containing the ID. Even if we manage to reuse the hidden URL, it will no longer be valid
THE SECURITY IS THUS MAXIMUM
Installation & Setup
Installation in JDE
Delivered JDE Objects
JDEUtil consists of several JDE/E1 objects, including:
- A P59VLVIG application
- A F59VGSEC table
These objects are delivered as a .par file, which must be restored in JDE by OMW. The objects must be promoted, packaged and deployed in all environments where JDEUtil is to run. The specific table must be generated in the different data sources.
Text Block Security
To ensure the correct behaviour of the application when launching the connection chain, it is necessary to set security to prevent the Encoding of the P59VLVIG application.
- Open the program P00950 (in web or fat client) and choose the screen output “Text Block” (which corresponds to type “K”)
- secure Encoding for all users (*PUBLIC) for the object P59VLVIG