oracle multi user function

How can I create a function that I can use from different users? It must work like built-in oracle function, which can be called from any user. I guess that this can be achieved by granting some privilege..?

Answers


This should do it for specific users:

GRANT EXECUTE ON your_function TO some_user;

You can allow access to all users this way:

GRANT EXECUTE ON your_function TO PUBLIC;

To reference this function from another users account, do this:

SELECT owner.your_function FROM dual;

If you want to avoid specifying the owning schema in the function reference, create a public synonym for it:

CREATE PUBLIC SYNONYM your_function FOR owner.your_function;

Then anyone can reference the function this way:

SELECT your_function FROM dual;

Need Your Help

Save / Load IOS data

ios load save

I've been attempting to get my app to save and load data from a set of arrays in the app, the odd issue is that when the app terminates (completely shut down) the data does not seem to load upon be...