Give a Grant a Function for All Bank User

[pyro]

I created with a function in the Oracle bench, however when access it (execute) inside the forms with another user it hangs, I realized that it can be a grant problem.
How do I authorize all the bank users using this function?

Environment information:
* Oracle version: 10g
* Operating system: Linux Red Hat.

[diegoleite]

Select all

Grant EXECUTE ON NOME_FUNCTION TO Usuario;

or

Select all

Grant EXECUTE ON NOME_FUNCTION TO ROLE;

[marcus.vpm]

You can use this too;

Select all

GRANT EXECUTE ON FUNCTION TO PUBLIC 
/ 
CREATE PUBLIC SYNONYM FUNCTION FOR FUNCTION 
/

[pyro]

I did the indicated but it has not worked yet, I will give a better analyzed.
vlw.

[marcus.vpm]

Select all

GRANT EXECUTE ON SCHEMA.NOME_FUNCTION TO PUBLIC 
/ 
CREATE PUBLIC SYNONYM NOME_FUNCTION FOR SCHEMA.NOME_FUNCTION 
/