9,310
edits
Line 630: | Line 630: | ||
* Any fetch executed on some table incorporates implicitly also shared records: | * Any fetch executed on some table incorporates implicitly also shared records: | ||
Original fetch <syntaxhighlight lang="SQL"> SELECT * FROM email WHERE condition</syntaxhighlight> is replaced by: | : Original fetch | ||
<syntaxhighlight lang="SQL">WITH emailSecurity as (SELECT * FROM email UNION SELECT shared emails from POA) | : <syntaxhighlight lang="SQL"> SELECT * FROM email WHERE condition</syntaxhighlight> | ||
: is replaced by: | |||
: <syntaxhighlight lang="SQL">WITH emailSecurity as (SELECT * FROM email UNION SELECT shared emails from POA) | |||
SELECT * FROM emailSecurity WHERE condition</syntaxhighlight> | SELECT * FROM emailSecurity WHERE condition</syntaxhighlight> | ||