GSquared (4/2/2010)
You can grant the right to create procedures specifically.Would look like this:
GRANT CREATE PROCEDURE TO bob;
if granting the rights granularly as GSquared posted, just bear in mind that you will also need to apply ALTER permissions too on the schema the sprocs are created in 😉
This is the way i would do it!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉