[dbo].[udfIsMssWebAtlasSudsUploadActive]

BUILD09 > MoversSuite2 > Scalar-valued Functions > dbo.udfIsMssWebAtlasSudsUploadActive

Properties
Permissions
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On

Permissions

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

CREATE FUNCTION [dbo].[udfIsMssWebAtlasSudsUploadActive]
()
RETURNS bit
AS
BEGIN
    return case when exists(
        select 1 from secModules
where secModules.Description='Atlas Suds Upload' and Active=1)
        then 1
        else 0 end
END
GO
GRANT EXECUTE ON  [dbo].[udfIsMssWebAtlasSudsUploadActive] TO [MssExec]
GO

Uses

[dbo].[SecModules]
dbo

Used By

[dbo].[MssWebGetOrderThirdPartyIntegrations]