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...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.