To protect PeopleSoft source data, create a database user and grant the user SELECT permission for the underlying physical database tables containing source data. Underlying physical table names begin with PS_, such as PS_LEDGER. To access the XLATTABLE table as a source, grant the user SELECT permission on the XLATTABLE table as well.

Use this database user name to configure the connection object in the Workflow Manager. The PowerCenter Integration Service uses this connection object to extract PeopleSoft source data.

When you configure a session to extract PeopleSoft source data, enter the owner name as the source table name prefix to access source data.