This discussion is archived
6 Replies Latest reply: Jan 18, 2013 5:00 AM by Arumugavel RSS

PS user in DBOWNER.sql Script

Arumugavel Newbie
Currently Being Moderated
Hi

While running dbowner.sql,instead of creating user called PS,can we give any other name for that schema.Is it mandatory to give the schema name called PS.

Thanks
Velu
  • 1. Re: PS user in DBOWNER.sql Script
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    Hi,

    I would say yes it is mandatory, no where during the installation is it stated that you can/must change this.
    Also in no other script this schema is variable or referenced
    PS cores uses this.


    For example, when I turn on trace and log in to Application Designer, you will the following

    RC=0 Dur=0.775000 Create Connection Info=Primary/[SID]/people/ Handle=04F07AD0
    RC=0 Dur=0.196000 Open Cursor Handle=04F07AD0
    RC=0 Dur=0.000000 COM Stmt=SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME=:1
    RC=0 Dur=0.000000 Bind-1 type=2 length=6 value=[SID]
    RC=0 Dur=0.014000 COM Stmt=SELECT OWNERID, TOOLSREL, TO_CHAR(LASTREFRESHDTTM,'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(LASTCHANGEDTTM,'YYYY-MM-DD HH24:MI:SS') FROM sysadm.PSSTATUS
    RC=0 Dur=0.000000 COM Stmt=SELECT DBID FROM SYSADM.PSSTATUS
    RC=0 Dur=0.000000 COM Stmt=SELECT VERSION, OPERPSWD, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1

    You can see that PSDBOWNER is references as PS.PSDBOWNER in the sql statement.

    So I would again say, do not change this schema, although dbowner.sql contains a public synonym.
    CREATE PUBLIC SYNONYM PSDBOWNER FOR PSDBOWNER;
    GRANT SELECT ON PSDBOWNER TO PUBLIC;

    Hakan
  • 2. Re: PS user in DBOWNER.sql Script
    Arumugavel Newbie
    Currently Being Moderated
    Hi

    once the connect ID has been verified why does it go for PSDBOWNER verification ??
    where this has been mention ..? anywhere in configuration manager...!
    If i create schema called "QS" rather than "PS" then while logging in APP DESIGNER would QS.PSDBOWNER be verified ??or is PS schema is peoplesoft delivered?


    Regards
    VELU
  • 3. Re: PS user in DBOWNER.sql Script
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    >
    once the connect ID has been verified why does it go for PSDBOWNER verification ??
    >

    PSDBOWNER contains the database name and the AccessID (SYSADM)
    After verifying the database name with the database name you supplied PeopleSoft logs in with the AccessID (SYSADM), this the schema that contains all PeopleSoft tables, views, etc.

    Again I would not change the schema PS.

    Why do you want to this anyway, why is this so important for you?

    Nicolas explained the logon sequence in detail in this tread {thread:id=2348496}

    Hakan

    Edited by: Hakan Biroglu on Jan 18, 2013 12:05 PM
  • 4. Re: PS user in DBOWNER.sql Script
    Arumugavel Newbie
    Currently Being Moderated
    Thanks Hakan

    How does app Designer searches for exactly 'PS' schema ...though many schema would be der in database....
    sorry for the trouble but just wanted to know how the connection is made with database...

    Velu
  • 5. Re: PS user in DBOWNER.sql Script
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    This is core PeopleTools, not to be defined anywhere.
  • 6. Re: PS user in DBOWNER.sql Script
    Arumugavel Newbie
    Currently Being Moderated
    once again thanks for clearing the doubt....

    velu.

    Edited by: Arumugavel on Jan 18, 2013 6:30 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points