PeopleSoft 登录
我正在构建一个 Web 应用程序，它将可以通过 jdbc 访问 PeopleSoft 的数据库。 我是否可以将 PeopleSoft 的 ID/密码用于我的自定义应用程序，这样访问我的网站的用户就不必拥有另一个用户名/密码？
I'm building a web application that will have access to PeopleSoft's database via jdbc.
Is it possible that I can use PeopleSoft's id/password for my custom application, so users accessing my website will not have to have another username/password?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
Peoplesoft 将用户详细信息存储在表 PSOPRDEN 中。
您将能够根据 PSOPRDEFN.OPRID 验证用户名。
密码字段为：OPERPSWD。
不幸的是，用于该字段的加密函数：
hash()只能在 peoplecode 中使用。如果您想使用单点登录，您应该能够通过自定义 USERMAINT.gbl 组件（可能在 saveprechange peoplecode 中）来实现，以使用可以从 JDBC 实现的加密算法将密码保存在您选择的第二个字段中以及。
Peoplesoft stores user details in the table PSOPRDEFN.
You will be able to verify the username against: PSOPRDEFN.OPRID.
The password field is: OPERPSWD.
Unfortunately the encryption function used for this field:
hash()is available only from within peoplecode.If you want to use a single sign on you should be able to do so by customizing the USERMAINT.gbl component perhaps in the saveprechange peoplecode, to save the password in a second field of your choice with an encryption algorithm that you can implement from JDBC as well.
如果您想重用 PeopleSoft 安全性，则需要在比 JDBC 更高的级别上直接连接到数据库。 您可以查看组件接口（可使用 Java 进行编码）或将 SOAP 消息发送到 PeopleSofts 集成网关 - 这两种方法都会使用 peopleSoft 自己的安全机制对您进行身份验证。
If you want to reuse PeopleSoft security, you'd need to connect at a higher level than JDBC straight into the database. You could look at a component interface (codeable in Java) or send a SOAP message into PeopleSofts Integration Gateway - both methods would authenticate you against peopleSoft using its own security mechanisms.
旧的方法是根据您的需要自定义 psuser.c 并重新编译为新的 dll，将其用于您的程序（假设您使用的是 Microsoft 平台）。 如上所述，您可以让 PeopleSoft 开发人员创建一个组件接口（或使用已交付的接口）。 您可以从 CI（模板）导出包装器 Java 或 C/C++ 代码。 然后可以在外部程序中使用此代码来调用 CI。 不管怎样，你必须与 peopletools 交互来调用他们的密码解密功能。
根据您的业务动态程度，无论您每天是否添加大量员工，您都可以使用应用程序消息传递将 psoprdefn 导出到另一个数据库。 在发送时，您可以根据需要对密码进行加密。 但正如您可以猜测的那样，这不是实时的。
我记得很久以前做过的一件事是让一个 peoplesoft 技术人员开发一个页面，其唯一功能是调用我的 java 类，并根据需要获取用户/密码。 一旦我有了它们，我就可以出发了。
The old way was to customize psuser.c to your needs and recompile as a new dll, used it your program, assuming you're on a Microsoft platform. As mentioned above, you could have a peoplesoft developer create a component interface ( or use the one that is delivered ). You can export wrapper Java or C/C++ code from a CI, a template. This code can then be used in an external program to call the CI. one way or the other, you have to interface with peopletools to call their decrypt for passwords.
Depending on how dynamic your business is, whether you add lots of employees each day, you could export psoprdefn using app messaging to another database. On the send, you could encrypt passwords however you like. But as you can surmise, this would not be real-time.
One thing I remember doing long ago was have a peoplesoft tech person develop a page the sole functionality of which was to call my java class and which obtained user/pswds as needed. Once I had them, I was good to go.
您可以使用 psjoa.jar ，这样您就可以使用 psoprdefn 表中的相同用户和密码通过 app.server 登录。
You can use the psjoa.jar , in that way you can signon via app.server using the same users and passwords in the psoprdefn table.
PeopleSoft 具有 LDAP 集成功能，但必须进行配置。 如果您通过组件接口周围的 Java 包装器进行访问，则可以在 PeopleSoft 中设置一个特殊帐户，该帐户只能访问底层组件，但必须将登录名/密码传递到组件接口中。 这可以加密或通过 https 发送。
PeopleSoft 还具有所谓的“行级”安全性，即对数据集进行分区的能力，例如，您的代码只能访问特定业务部门内的员工数据或特定业务线的会计信息。 这一切都在 PeopleSoft 在线安全应用程序中进行控制。
PeopleSoft has an LDAP integration ability but it has to be configured. If you are accessing via a Java wrapper around a component interface, a special account can be set up in PeopleSoft with access only to the underlying component, but the login/password would have to be passed into the component interface. This can be encrypted or sent over https.
PeopleSoft also has what it calls "row level" security - the ability to partition data sets so that for example your code could only access employee data within a specific business unit or accounting info for a particular line of business. This is all controlled within the PeopleSoft online security application.