To protect PeopleSoft metadata, create a new database user and grant the user SELECT permission for PeopleSoft metadata tables. PeopleSoft system table names begin with PS, such as PSRECDEFN.

Enter this database user name in the Import from PeopleSoft dialog box when you use the Designer to import PeopleSoft source definitions. Since this user name is not the owner of the PeopleSoft system tables, you also enter the table owner name to import PeopleSoft source definitions.

To allow the Designer to import PeopleSoft source definitions, the database user requires SELECT permission on the following PeopleSoft metadata tables:

You can alternatively grant SELECT permission to

all

PeopleSoft metadata tables to enable importing PeopleSoft source definitions.