CHAPTER 3Database Connectivity

All but one of the database objects in a PeopleSoft database are contained in a single Oracle schema. All PeopleSoft processes that connect directly to the database via SQL*Net go through the standard PeopleSoft signon processing, negotiating security and ending up connected to that schema. (Thereafter, security is handled by PeopleTools, not the database.)

This chapter describes the database schemas that PeopleSoft creates, their privileges, and how those privileges are used by the signon process, explaining what this reveals about the structure of PeopleSoft databases.

PeopleSoft Database vs. Oracle Database

It is not uncommon in the IT industry for different vendors to use the same word to mean very different ...

Get PeopleSoft for the Oracle DBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.