System User in EnterpriseOne
Suppose you sign in to EnterpriseOne with a userId ZHan091, does your application connect to the database with the same userId and password.No it is not.Because, there can be hundreds of E1 users and it is not possible to create all those users at the database end.It is also not wise to create so many connections to the database.
System User or Proxy User
A limited set of users are created at the database end and multiple E1 users use these limited system/proxy users to connect to the back end database.The advantage is easy maintenance and possibility to share the connections among E1 users.
These system user/password are stored in F98OWSEC,F98OWPU tables in encrypted format.The F98OWSEC table contains the E1 user-Datasource-Proxy user mapping.
The Security Kernel on the Enterprise Server reads this table, extracts the system user and sends to the Fat/Jas server.
When the SecurityServer= blank in the clients JDE.ini file, the user id/password entered in the log in screen are directly used to connect to the database.