我如何保护我的存储过程 [英] how can i protect from my stored procedure

问题描述

我创建了一个像这样的存储过程

i created a stored procedure like this

create PROCEDURE [dbo].[GetUsersWithProtection]
	-- Add the parameters for the stored procedure here
WITH Encryption,
     EXECUTE AS OWNER
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
		SELECT * from Table_Users
END

但是您可以使用此链接或许多其他应用程序打开它

所以我的问题是如何保护存储过程?
谢谢

but you can open it with This Link or many other applications

so my question is how can i protect a stored procedure ?
thank you

推荐答案

通常，赠款用于保护您的数据库资产.
http://msdn.microsoft.com/en-us/library/ms187965.aspx [ ^ ]

祝你好运！

Normally grants are used to protect your database assets.
http://msdn.microsoft.com/en-us/library/ms187965.aspx[^]

Good luck!

这篇关于我如何保护我的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！