ARUDSUSER SQL query in Advanced Authentication

Products

• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)
• CA Advanced Authentication
• CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort)

Issue/Introduction

Provide the query which is used to add the users in the ARUDSUSER table.

Environment

Release : 9.1

Component : AuthMinder(Arcot WebFort)

Resolution

Below is the query used to add the users in the ARUDSUSER table.

****************************************************************************************

INSERT INTO ARUDSUSER 
   ( USERREFID, USERID, ORGNAME, STATUS, TELEPHONENUMBER,
    EMAILADDR, FNAME, MNAME, LNAME, PAM, 
    PAMURL, IMAGE, INFOLIST, INTERNALATTR1, INTERNALATTR2, INTERNALATTR3, DATECREATED, 
    DATEMODIFIED    ) 
  VALUES
   ( #userRefID:INTEGER#,#userID:VARCHAR: #, #orgName:VARCHAR: #, #status#, #telephoneNumber:VARCHAR: #, 
    #emailAddr:VARCHAR: #, #fName:VARCHAR: #, #mName:VARCHAR: #, #lName:VARCHAR: #, 
    #pam:VARCHAR: #, #pamURL:VARCHAR: #, #image:VARBINARY: #, #infoList:VARCHAR: #,
                #internalAttr1:VARCHAR: #, #internalAttr2:VARCHAR: #, #internalAttr3:VARCHAR: #, #dateCreated#, #dateModified# )

*****************************************************************************************

This is the query for the sequence creation -

============================================================

create sequence ARUDSUSERREFIDSEQ
                start with 1
                increment by 1
                cache 20;

create or replace
procedure sequenceNextVal(seq_id in varchar2, ref_id out integer)
as

begin

  select ARUDSUSERREFIDSEQ.NEXTVAL into ref_id from dual;

end sequenceNextVal;

======================================================