SQL-028: Retrieve security grants for one menu item¶

This statement is the RetrieveForItemSQL implementation of clsMenuSecurityCollection.Criteria, executed from BeforeRetrieve against MENU_SECURITY. Retrieve security grants for one menu item.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:MenuItemSeqNum`	Input	Decimal	N/A	Menu item whose grants are retrieved

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 security grants for one menu item
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_ITEM_SEQ_NUM = :MenuItemSeqNum

Operations and processes¶

Load security grants for an item

Business rules¶

BR-MENU-001: Scoped vs. unfiltered retrieval
BR-MENU-021: Cascading child security-group save
BR-MENU-024: Lazy-loaded navigation properties

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

Sources¶

SAIF.Business.Menu/clsMenuSecurityCollection.vb