Permissions for a stored procedure with bulk insert
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.
精彩评论