Problem in connecting Application designer after data mover 1

[johnramesh]

Dear friends,

I have a problem running Application Designer in 2-tier mode. It gives gives "invalid userid and password" when i try to connect Application Designer. I have successfully completed the installation as mentioned in "Installation and Administration

for Oracle" manual till executing scripts in data mover.

I am running Oracle 8.1.7 and PeopleTools 8.1.6

1. Created oracle database with following option
Database Name: dev8.world
SID: dev8

2. Connected in SQL Plus with internal/manager@dev8 and executed following scripts.
(i) ran utlspace.sql

(i) ran rollback.sql

(i) ran dbowner.sql - created user PS/PS

(i) ran PTDDL.SQl - created tablespaces for a PT8 PTDMO database)

(i) ran psroles.sql

(i) ran psadmin.sql - created user psowner/psowner

(i) ran connect.sql - created user people/peop1e

3. ran database setup with following configuration which created HCDMOORA.DMS
Database: Oracle
Database type: Non-unicode
Character set: WEBISO8859P15
PeopleSoft Application: HC-ENG
Database Name: dev8
Symbolic ID: dev8
Access ID: SYSADM
Access Password: SYSADM
Connect ID: PEOPLE
Database type: Demo

4. logged in data mover with following parameters
Database type: Oracle
Database Name: DEV8
User ID: psowner
Password: psowner

and successfully ran HCDMOORA.DMS script

5. Trying to login in application designer with following parameters
Database type: Oracle
Database Name: DEV8
User ID: psowner
Password: psowner

gives "invalid userid and password"

I have tried with all database userid/password, it did not help.

Please let me know what i am missing and let me know the database userid/pwd and Peoplesoft userid/pwd differnce.

I am fully confused with the database users PS, Database owner id (PSOWNER), connect id (People) and access id (SYSADM).

Please someone clarify why these IDs for and how can i get to connect to Application Designer after reading above mentioned installation.

Thanks so much!!!

 

[PSJerome]

Hello,

Application Designer and Data Mover logon are not the same
==========================================================

* Data Mover: allows you to log in using two different modes - bootstrap and regular.
-- Bootstrap mode: requires an ID that is not a PeopleSoft ID which means it is not located in the PSOPRDEFN table. For example, SYSADM.
-- Regular mode: requires that the ID be a PeopleSOft ID and is located in the PSOPRDEFN table. For example, PS for HRMS and VP1 for Financials.
-- Data Mover determines the mode by the presence or absence of the ID in the PSOPRDEFN table
* Application Designer: the ID must be in the PSOPRDEFN table. For example, PS for HRMS and VP1 for Financials.
The ability to log into Data Mover without being able to log on to PeopleSoft is normal. There are Data Mover commands that you cannot run in bootstrap mode. By doing this PeopleSoft only allows PeopleSoft users to perform certain Data Mover commands on the database.


Database IDs versus PeopleSoft IDs
==================================

* Database IDs: allow access to the database but are not PeopleSoft IDs. A database ID will not allow you to log on to the PeopleSoft application. A database ID will allow you to use the Data Mover tool, but you will not be able to access the PeopleSoft HRMS/Fin application. The SYSADM ID is in the Oracle users table, but will not allow you to log onto PeopleSoft.

* PeopleSoft IDs: allow access to the PeopleSoft application and are called Operator IDs. They do not have to be database IDs - starting at PeopleSoft 7 for 3-tier access - and for security it is better that the IDs are not in the Oracle users table. Therefore, for PeopleSoft 8, most likely you will not find PeopleSoft ID PS in the users table in Oracle. There is an addiitonal ID called the Symbolic ID (SYSADM1 or even SYSADM - whatever you want), but this ID cannot be used to sign on to PeopleSoft or the database.


How are the Database IDs and PeopleSoft IDs connected?
======================================================

* Database IDs: for PeopleSoft there two primary database IDs.
-- SYSADM: this ID has access to all of the PeopleSoft tables and is referred to as the owner ID
-- people: this ID has SQL GRANT and SELECT access to four tables (for Oracle and some other databases) - PSOPRDEFN, PSDBOWNER, PSACCESSPRFL, PSSTATUS. This ID is called the connect ID.

* PeopleSoft IDs: Lets use Operator ID PS and Symbolic ID SYSADM1

* When you sign on to PeopleSoft using PS:
-- the connect ID (people) is pulled from the workstation configuration and passed to the database
-- the connect ID signs on to the database and SELECTS the PS ID from PSOPRDEFN. The Symbolic ID is also pulled from PSOPRDEFN.
-- if the PS ID is found, sign on continues; if not, sign on ends
-- the Symbolic ID selected is then used to pull the owner ID and password from the PSACCESSPRFL table
-- PSDBOWNER table is checked to see if the SYSADM ID has access to the database
-- the people ID disconnects from the database
-- PeopleSoft connects again to the database using the owner ID SYSADM
-- PeopleSoft security checks are run and you are not logged in:
- to the database we are always user SYSADM
- to PeopleSoft executables we are PS

All of this assumes the workstation configuration is correct and all scripts were run using the correct Oracle database ID to ensure GRANTS and SELECTS access is given to the correct IDs.

You will find additional information in the PeopleBooks on security and the PeopleSoft sign-on process.

If anyone has any additions or corrections, please post.

 

[rekclaw]

PSJerome...Nice description!

 

[ugen9]

HOW DO WE CREATE TABLES PSSTATUS AND PSOPRDEFN

 

[PSJerome]

Hello ugen9,

PSSTATUS and PSOPRDEFN are automatically created for you when you run the script created from the PeopleSoft Database Setup utility.

If you cannot see the tables, make sure the database user ID you use to sign into the database has at least SELECT access to the tables.

If not, review the GRANT script and verify the script was run correctly for your database.

 

[mbodempudi]

Hi, My friend ,

I have same problem . After I can not log in to application desinger. Here is solution.

Try with capital PS as userid and small letter ps as password. I was able to login with this combination.

Murali Bodempudi

 

[Guest_imported]

I have do do a security audit of a company using Peoplesoft, how do I know (in PSOPRDEFN table) wich ID's are Internal and wich ones were created?

Thanks.

 

[PSJerome]

Hello Nyperez,

To seek answers that fully address the questions you have, I would recommend that you create a new thread discussing "PeopleSoft Security Audits" since this thread discusses PeopleSoft installation issues. For example, a typical PeopleSoft security administrator would not read threads or discussion topics relating to a PeopleSoft installation; therefore, you would miss this person's valueable input.

Also, I am not familiar with how you define the difference between an "Internal" ID and a "created" ID. If you are attempting to determine which Operator IDs and Operator Classes were delivered with PeopleSoft, please review data contained in the PSOPRDEFN table for the Demo database.

If this response does not address your issue, please be more descriptive in your question.

Thanks.

 

[ORAPSOFT]

Hi there, I know that you already fix your problem, for this reason I want to ask you something, let me talk to you a couple of words before, I have installed the version 7.6 and 8.16 of PeopleTools over SQL Server 7.0 and 2000, now I am trying to do it on Oracle, so, I do not have the license for that, in version 7.6, a litle change on the last digit of this , great yo can install over Oracle, I have tried to do it for the Tools 8.16 and it does not work, can you help me, I have HR 8.3 over Tools 8.16.
The question is:

Do you have a valid license for the PeopleTools 8.16 over Oracle? What about any application, HR, EPM, even SA? or Can you share the media for me, just a few days, in FTP or HTTP?

Help me, I am entrepeneur and I want to improve my skills, actually, I have Oracle 8.1

Best Regards

Vinny

 

[ozzy0sbourne]

Yow!

I've had the same problem as John. But I don't know how to login to the Peoplesoft database with PS user. The Password is encrypted. Any way of decrypting it?