Home > PeopleCode, Security > Signon PeopleCode modification

Signon PeopleCode modification

December 11, 2007 Leave a comment Go to comments

We had a requirement to track unsuccessful login details. PeopleSoft delivered PSACCESSLOG table gives only successful login details. To get unsuccessful login details, I modified PASSWORD_CONTROLS() function in  FUNCLIB_PWDCNTL.PWDCNTL.FieldChangePeopleCode

To do this I created a record ACCESS_DET with OPRID, LOGGINDTTM etc fields. This record stores all unsuccessful log-ins data. Then Open the peoplecode (Record.FUNCLIB_PWDCNTL, Field.PWDCNTL, Peoplecode.FieldChange)  and added the below shown PeopleCode inside the password_controls() function, where the %PSAuthResult value is negative.

      Local Record &ACCESSREC;
      Local SQL &ACCESS_SQL;
     
      &ACCESSREC = CreateRecord(Record.ACCESS_DET);
      &ACCESS_SQL = CreateSQL(“%Insert(:1)”);
     
      &ACCESSREC.OPRID.Value = &USERID;
      &ACCESSREC.LOGIPADDRESS.Value = ” “;
      &ACCESSREC.LOGINDTTM.Value = %Datetime;
      &ACCESSREC.LOGOUTDTTM.Value = “”;
      &ACCESSREC.FF_SUCCESS_FLG.Value = “N”;
      &ACCESSREC.LOGINATTEMPTS.Value = &FailedNum;
     
      &ACCESS_SQL.Execute(&ACCESSREC);
      &ACCESS_SQL.Close();

Related articles in other blogs:

Advertisements
  1. santosh
    April 4, 2008 at 12:14 pm

    I want to know where the exact querying of the user logs in takes place. Say If some person logs in with “TPEPPER” as UserID. Then where are the queries corresponding to the querying of TPEPPER’s Roles and Permission lists takes place. I didnt find anything of this kind in signon peoplecode

  2. balaglobal
    April 4, 2008 at 3:38 pm

    Santosh,
    sign on peoplecode is not designed for what you are searching. Roles and permissions will be queried after signon, the code is not open to my knowledge. I am not sure why you need to know the query for roles and permission List.

    Thanks,
    Bala.

  3. santosh
    April 5, 2008 at 3:39 am

    Hi bala,
    Thanks for the response
    but then i have a req wherein the OPRID is sent from an XML trigger from an external portal , now i vil have to capture that “OPRID” and vil have to provide the authentication. however that OPRID vil b in my PSOPRDEFN. Now where can i write the suitable query or code. Coz SetAuthentication Result sets after the login is successful but to make it successful where can i write the suitable code?

  4. balaglobal
    April 5, 2008 at 1:06 pm

    Santhosh,
    Sorry, I am still not clear.
    Are you planning to capture the oprid from XML using peoplecode?
    It looks like you need integration tool than simple peoplecode.
    My understanding is an external portal is trying to login to peoplesoft using an xml trigger. If this is correct you may have to use integration tools, like integration broker or business interlink or component interface to give selective component access to the oprid.

  5. santosh
    April 5, 2008 at 5:54 pm

    bull’s eye. I want to integrate external portal login to peoplesoft portal . It is not single signon but in the similar lines. U said that i have to use component buffer or integration broker to provide the required page but to provide that access i need to pass the login that is where i am concerned about

  6. satya nemani
    May 26, 2008 at 11:36 am

    Hi,
    Can you please tell me how and where to use SetAuthenticationResult function in PeopleSoft. Because I have already used it signonpeoplecode to customize login, but then its working..
    Thanks in Advance

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: