Exclusive Row Security

This table shows the records that you define using the Row application in Security Workbench when you use exclusive row security to secure your system:

User	Table	Data item	From Value	Thru Value	Add	Change	Delete	View	Alias
MG5700778	*ALL	CostCenter	1	20	N	Y	N	Y	MCU
MG5700778	*ALL	CostCenter	21	50	N	N	N	N	MCU
MG5700778	*ALL	CostCenter	51	70	N	N	N	Y	MCU
MG5700778	*ALL	CostCenter	71	ZZZZZZZZ	N	N	N	N	MCU

This example shows the Select operation that the system performs against the F0101 table:

SELECT * FROM TESTDTA.F0101 WHERE ( ABMCU NOT BETWEEN ' 21' AND ' 50'  
AND ABMCU NOT BETWEEN ' 71' AND ' ZZZZZZZZ' ) ORDER BY ABAN8 ASC 

This example shows the Update operation that the system performs against the F0101 table:

UPDATE TESTDTA.F0101 SET
ABALKY='MG5700778',ABTAX='456456456',ABALPH='John
Doe',ABDC='JOHNDOE',ABMCU=' 1',ABSIC=' ',ABLNGP=' ',ABAT1='E',ABCM=' 
',ABTAXC='  WHERE ( ABAN8 = 9999999.000000 ) AND ( ABMCU NOT BETWEEN ' 
21' AND ' 50' AND ABMCU NOT BETWEEN ' 51' AND ' 70' AND ABMCU NOT 
BETWEEN ' 71' AND ' ZZZZZZZZ' )

Note: Row security is applied for the range of values that have N in the appropriate Add/Change/Delete/View action.