SQL-008: Insert security question¶

Inserts a new user security question and answer into EXT_USER_SECURITY_QUESTION, used in password recovery workflows.

Classification¶

Field	Value
SQL ID	SQL-008
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsUserSecurityQuestion`
Criteria property	`InsertSQL`
Lifecycle method	`BeforeInsert`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:UserSecurityQuestionID`	Input	Decimal	N/A	`EXT_USER_SEC_QUESTION_SEQ_NUM` — primary key.
`:UserID`	Input	Decimal	N/A	Owning `EXT_USER_SEQ_NUM`.
`:SecurityQuestionCode`	Input	String	5	Selected question code.
`:Answer`	Input	String	200	User's answer text.
`:CreateUser`	Input	String	30	Username creating the record.
`:CreateDate`	Input	DateTime	N/A	Record creation timestamp.
`:UpdateUser`	Input	String	30	Username of last update.
`:UpdateDate`	Input	DateTime	N/A	Last update timestamp.
`:UpdateNum`	Input	Decimal	N/A	Optimistic-concurrency counter.

Tables¶

Table	Access	Columns used
EXT_USER_SECURITY_QUESTION	INSERT	`EXT_USER_SEC_QUESTION_SEQ_NUM`, `EXT_USER_SEQ_NUM`, `EXT_USER_SEC_QUESTION_CODE`, `ANSWER_TEXT`, `CREATE_USER`, `CREATE_DATE`, `UPDATE_USER`, `UPDATE_DATE`, `UPDATE_NUM`

Sample SQL¶

INSERT INTO EXT_USER_SECURITY_QUESTION (
    EXT_USER_SEC_QUESTION_SEQ_NUM, EXT_USER_SEQ_NUM, EXT_USER_SEC_QUESTION_CODE,
    ANSWER_TEXT, CREATE_USER, CREATE_DATE, UPDATE_USER, UPDATE_DATE, UPDATE_NUM
)
VALUES (
    :UserSecurityQuestionID, :UserID, :SecurityQuestionCode,
    :Answer, :CreateUser, :CreateDate, :UpdateUser, :UpdateDate, :UpdateNum
)

Operations and processes¶

Security question management

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business.External.Users\clsUserSecurityQuestion.vb