6 Replies Latest reply: Jan 18, 2013 7:00 AM by Arumugavel RSS

    PS user in DBOWNER.sql Script

    Arumugavel
      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
          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
            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
              >
              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
                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
                  This is core PeopleTools, not to be defined anywhere.
                  • 6. Re: PS user in DBOWNER.sql Script
                    Arumugavel
                    once again thanks for clearing the doubt....

                    velu.

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