用户没有权限在执行exec sp_addmessage时执行此操作 [英] User does not have permission to perform this action while executing exec sp_addmessage

问题描述

大家好，

当我尝试执行以下过程时，出现错误消息.

Hi All,

when I try to execute the following Procedure I get the error message.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE SP_Logical
	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

declare @device_id int
declare @userName varchar(100)
declare @countMsg varchar(1000)
set @device_id=1
set @userName=''sue''
    DELETE FROM managed_component_logical_storage
WHERE surrogate_disk_subsystem_id 
IN 
(
	SELECT surrogate_disk_subsystem_id 
	FROM managed_component_physical_storage
	WHERE managed_system_id = @device_id
)
set @countMsg =''User(''+@userName+'') have  deleted (''+ convert(varchar(3),@@rowcount) +'')  from managed_component_logical_storage1''
-- Writes the messages in System Log
exec sp_addmessage 50001,16,	@countMsg ,''us_english'',	true, @replace=''replace''
END
GO

错误消息是用户没有执行此操作的权限".任何帮助将不胜感激.

The error message is "User does not have permission to perform this action". Any help would be appreciated.

推荐答案

请检查以下链接，该链接可能会解决您的问题.

Microsoft SQL Server角色 [在SQL Server上管理用户权限 [ ^ ]

谢谢，
Imdadhusen

Hi,

Please check following link that may be resolve your issue.

Microsoft SQL Server roles[^]

Managing Users Permissions on SQL Server[^]

Thanks,
Imdadhusen

这篇关于用户没有权限在执行exec sp_addmessage时执行此操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！