开发者

Permissions for a stored procedure with bulk insert

开发者 https://www.devze.com 2023-01-22 19:44 出处:网络
I want to create a stored procedure to perform a bulk insert so a user I grant access to the stored procedure can run it without any other permissions.

I want to create a stored procedure to perform a bulk insert so a user I grant access to the stored procedure can run it without any other permissions.

Is there any way I 开发者_Go百科can grant "ADMINISTER BULK OPERATIONS" to the stored procedure so I don't have to grant server wide bulk op permissions to the user?

Is there any other solution?

I am using SQL Server 2005.


You could modify the stored procedure to use "EXECUTE AS" to have it run under a different context.

0

精彩评论

暂无评论...
验证码 换一张
取 消