I have a stored Proc "SP_TEST" which also has "GRANT EXECUTE TO USER1" . The username is different from dev to prod so whats the best way to deploy it to prod with out manual intervention ? Is it using proxy user ?
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman