Summary Table
Categories |
Total Count |
PII |
0 |
URL |
0 |
DNS |
0 |
EKL |
0 |
IP |
0 |
PORT |
0 |
VsID |
0 |
CF |
0 |
AI |
0 |
VPD |
0 |
PL |
0 |
Other |
0 |
File Content
?-- =============================================
-- Description: Identifies true/false if the user is a national user
--
-- Maintenance Log:
--
-- Update By Update Date Description
-- ----------- --------- ----------------------------
-- Ken Baker 03/22/2012 Created
-- =============================================
CREATE FUNCTION seclyr.[ufnIsNationalUser]
(
@userId int,
@moduleIds tinyint
)
RETURNS bit
AS
BEGIN
DECLARE @isNationalUser bit,
@accessLevelId tinyint;
SET @isNationalUser = 0;
SELECT @accessLevelId = seclyr.ufnGetAccessLevelConstant('National');
IF @userId Is Null Or @userId = 0
BEGIN
SET @isNationalUser = 1;
END
ELSE
BEGIN
IF EXISTS (SELECT UserID
FROM seclyr.UserRoles
WHERE UserID = @userId
AND AccessStatus = 'Approved'
AND AccessLevelID = @accessLevelId
AND (ModuleID In(SELECT [Value] FROM ufnSplit(',', @moduleIds)) OR @moduleIds IS NULL))
BEGIN
SET @isNationalUser = 1;
END
END
RETURN @isNationalUser;
END
GO