LISTING 1: The V_SecAccess View

CREATE VIEW V_SecAccess
…..
AS
SELECT
OrgCode
FROM
SecurityAccess
WHERE
SUSER_SNAME() = LoginID