I keep looking this up. so it has gain its place in this site:
GRANT EXECUTE ON procedureName to username
slashgeo maploser