oracle多用户功能 [英] oracle multi user function

问题描述

如何创建可供不同用户使用的功能?它必须像内置的oracle函数一样工作，可以从任何用户调用它.我想这可以通过授予一些特权来实现.

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

推荐答案

这应该针对特定用户:

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;

这篇关于oracle多用户功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！