Which of the following are true with respect to validate sign on with database option enabled in psadmin?

1. The application server first attempts to connect to database using the user id and password as part of the database connection string.2. User must be defined on either the operating system or the database and within the PeopleSoft.
  • Interview Candidate
  • 1
  • 2477

Showing Answers 1 - 1 of 1 Answers

Rahul Yadav

  • Jun 10th, 2007
 

When a user signs into Application server(App designer).The App server initially connects to databse using connect ID/password and UserId/Password present in PSAPPSRV.cfg file.

After logging into database; the app server issues Select commands on security tables PSOPRDEFN,PSACCESSPRFL,PSSTATUS to retrieve Access id/Password and symbolic ID/password.

Once the values are retrieved the application server disconnects from database.

And connects to database using Access id retrieved in the above step to maintain a consistent seamless Database connectivity.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions