SQL-027: Retrieve all security grants

This statement is the RetrieveSQL implementation of clsMenuSecurityCollection.Criteria, executed from BeforeRetrieve against MENU_SECURITY. Retrieve all security grants.

Classification

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

Parameters

This statement takes no bind parameters.

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 all security grants
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

Operations and processes

• Load security grants for an item

Business rules

• BR-MENU-001: Scoped vs. unfiltered retrieval
• 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