I want to allow a batch process to drop a constaint on a table and do bcp-in, then put the constraint back. I dont want to give alter privileges on that table to BatchID. So, I wrote a stored proc in the following way:
create proc dbo.drop_contraint_B4_bcp as
ALTER TABLE dbo.my_table DROP CONSTRAINT my_const
GRANT EXECUTE ON dbo. drop_contraint_B4_bcp TO BatchID
But, when BatchID executes the above procedure, error -4 (permission error) is being returned.