How do you grant privileges to other users so that they can modify your procedure?

Grant update, alter on test_proc to scott; -- This does not work!