Connector Guides › Connectors Guide › Connecting to Endpoints › PeopleSoft Connector › Update PeopleSoft Permissions › Running the SQL Script

Running the SQL Script

Note: The SQL script supplied with the Connector has been tested on PeopleSoft with a SQL Server database. For databases other than SQL Server, it may be necessary to use the second method.

The script assumes a database name of PTSYS. If PeopleSoft is using a database with a name other then PTSYS, you must edit the script and replace all instances of PTSYS with the name being used. If the PeopleSoft installation has multiple databases, the script should be run on all databases.

To run the SQL script:

1. Copy the %JCS_HOME%\resource\pps\setperms.sql file to a location on or accessible to the PeopleSoft Application Server.

   where

   JCS_HOME is the installation directory of the Java CS

   C:\Program Files\CA\Identity Manager\Connector Server
   

2. Open the Microsoft SQL Server Query Analyzer and select File > Open…
3. Browse to the directory where setperms.sql file is located, and select this file.
4. Select Query > Execute to run the script.

   The Connector has been configured and is ready to use.