Page History

...

    [Netid] [varchar](30) NULL

) ON [PRIMARY]

Image Added

CREATE TABLE [dbo].[Orders](

...

    [ACCT_NBR] [varchar](10) NULL

) ON [PRIMARY]

Image Added

Create Function fn_securitypredicate (@ACCT_NBR sysname)

...

dbo.fn_securitypredicate(ACCT_NBR)

on dbo.orders

Testing Result

EXECUTE AS USER = 'bb57';

select * from dbo.predicate_tab order by netid asc

select * from dbo.orders

REVERT;

Image Added