granting execute to functions, packages, etc through roles

[gandolf989]

no, you cannot access stored procedures via roles

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.