[dbo].[MssWebDeleteEmailSignature]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebDeleteEmailSignature

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@inSysUserId	int	4
@inSignatureId	int	4

Permissions

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

create procedure [dbo].[MssWebDeleteEmailSignature]
@inSysUserId Int,
@inSignatureId Int
as
begin
    delete from
    SysuserEmailSignature
    where SysuserEmailSignature.SysuserFID = @inSysUserId
    and SysuserEmailSignature.SysuserEmailSignatureID = @inSignatureId;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebDeleteEmailSignature] TO [MssExec]
GO

Uses

[dbo].[SysuserEmailSignature]
dbo