View: dbo.Privilege_Requiring_Compliance_View | |||
View definition | |||
-- Privileges to exclude if there's no Compliance license. -- Compliance ----------------------------------------------------------- -- If this list changes set Firm.has_compliance to true so -- if the user doesn't have a Compliance license we'll react. ----------------------------------------------------------- CREATE VIEW dbo.Privilege_Requiring_Compliance_View AS SELECT privilege_KEY = P.privilege_KEY FROM dbo.Privilege P WHERE privilege_KEY IN ( 44, -- SBPR_Setup_FirmInfo_TaxAgt 80, -- SBPR_Setup_FirmInfo_TaxAgt_Main 256, -- SBPR_Setup_FirmInfo_TaxAgt_Main_View 257, -- SBPR_Setup_FirmInfo_TaxAgt_Main_Add 401, -- SBPR_Setup_FirmInfo_TaxAgt_Main_Edit 258, -- SBPR_Setup_FirmInfo_TaxAgt_Main_Del 81, -- SBPR_Setup_FirmInfo_TaxAgt_DirDep 402, -- SBPR_Setup_FirmInfo_TaxAgt_DirDep_View 403) -- SBPR_Setup_FirmInfo_TaxAgt_DirDep_Edit | |||