granting execute to functions, packages, etc through roles

[davey23uk]

Are you sure about that? I know you need an explicit grant to access an object from within a
stored procedure, however to access a stored procedure from the sql prompt I would think
that a role would work as well as a direct grant.

indeed, I mis-read that, need direct access to the table.

You can grant access to a stored procedure to a role - need to make sure you have the privs on any underlying objects as well if that's appropriate