SQL-026: Retrieve one security grant by sequence number¶

This statement is the RetrieveSQL implementation of clsMenuSecurity.Criteria, executed from BeforeRetrieve against MENU_SECURITY. Retrieve one security grant by sequence number.

Classification¶

Field	Value
SQL ID	SQL-026
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]`**
Command type	Text
Business object	`clsMenuSecurity`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:MenuSecuritySeqNum`	Input	Decimal	N/A	Security grant row to look up

Tables¶

Table	Access	Columns used
MENU_SECURITY	SELECT	MENU_SECURITY_SEQ_NUM, MENU_ITEM_SEQ_NUM, SECURITY_GROUP_TXT, UPDATE_DATE, UPDATE_USER

Sample SQL¶

-- Retrieve one security grant by sequence number
Select
  MENU_SECURITY.MENU_SECURITY_SEQ_NUM as MenuSecuritySeqNum,
  MENU_SECURITY.MENU_ITEM_SEQ_NUM as MenuItemSeqNum,
  MENU_SECURITY.SECURITY_GROUP_TXT as SecurityGroup,
  MENU_SECURITY.UPDATE_DATE as UpdateDate,
  MENU_SECURITY.UPDATE_USER as UpdateUser
From
  MENU_SECURITY
Where
  MENU_SECURITY.MENU_SECURITY_SEQ_NUM = :MenuSecuritySeqNum

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

SAIF.Business.Menu/clsMenuSecurity.vb