How to Retrieve AccessID & AccessPWD for a PeopleSoft Environment

最新推荐文章于 2025-03-12 09:30:00 发布

转载最新推荐文章于 2025-03-12 09:30:00 发布 · 1.6k 阅读

peoplesoft 专栏收录该内容

203 篇文章

订阅专栏

本文介绍了一种通过创建特殊进程类型并利用批处理文件在PeopleSoft环境中检索敏感数据库凭据的方法。这种方法展示了如何绕过常规的安全措施，并强调了限制开发者访问的重要性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Most of us follow the wa terfall model of SDLC within the organizations we work. Various teams are involved at various stages of the model. Each Team has their set of environments where they are the superusers. If we extend this to PeopleSoft, post Unit Testing, developers are not needed/required to have write access in the rest of the environments of SDLC. But what if, you could actually retrieve the ACCESS ID & ACCESS PWD (RDBMS ID which has access to the PeopleSoft schema) without the PSAdmins/DBA being aware. What is needed is explained below.

1. Create a command/batch file with this line - " @echo %1"
Place this file under %PS_HOME%\bin\server\WINX86

2. Create a new Process Type in PeopleSoft. Let's call it - " COMMANDLINE"

3. Create a Process "RETPWD" which will have the Process Type as "COMMANDLINE". I'm using Microsoft as the Database type as the PS DB is hosted on MSSQL 2005 SP2

4. Add this Process Type to your Server definition. Say PSNT

5. Bounce the batch server
6. Run the process.
7. The process may fail, do not panic, check the log if it has been posted to report repository or you could navigate to the prcs log directory for your batch server and locate the log. It should show you something like - "DBNAME/Access ID/Access PWD"