PeopleSoft - How does the PeopleSoft database interact with the Oracle? posted
by Babu Kunwar
How does the PeopleSoft database interact with the Oracle?
A Peoplesoft database is expression which point out a database containing
Peoplesoft objects. For Oracle and only for Oracle, Peoplesoft consists in 3
schemas namely:
-
PS (PSDBOWNER table owner),
-
PEOPLE (for connection checking) and
-
SYSADM (by default), the last one contains all the objects/data.
One of the database objects is connected with single Oracle schema, and all
processes that connect to the database use the standard PSFT login procedure.
PSFT login is used because to refer to the collection of tables in the
administrative schema within an Oracle database. Every process that makes a
2-tier connection to the database identifies itself with a PSFT user or
operator ID. Hence the interaction goes.
|
