CREATE PROCEDURE [dbo].[UpdatePolicy]
@PolicyID as uniqueidentifier,
@PrimarySecDesc as image,
@SecondarySecDesc as ntext = NULL,
@AuthType int
AS
UPDATE SecData SET NtSecDescPrimary = @PrimarySecDesc,
NtSecDescSecondary = @SecondarySecDesc
WHERE SecData.PolicyID = @PolicyID
AND SecData.AuthType = @AuthType

GO
GRANT EXECUTE ON  [dbo].[UpdatePolicy] TO [RSExecRole]
GO