PeopleSoft logins

Question

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?

Answer 1

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.

Answer 2

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.