Oracle Security API - FND_FUCTION.TEST
发布日期:2021-07-18 15:07:55 浏览次数:2 分类:技术文章

本文共 1093 字,大约阅读时间需要 3 分钟。

FND_FUCTION.TEST(Function_Name)


Test if function is accessible under current responsibility.TRUE if function is accessible.

This function Only checks static function security, and global object type grants from data security.
Because this routine does not take the object id and instance pks, it cannot test for most data security grants, and therefore it should not be used if the object id and/or instance pks are known.
This is here for cases where performance is critical, and for backwards compatibility, but in general new code should use TEST_INSTANCE instead if acting on a particular object instance (database row).


Example

There is function:HELLOWORLD,which is under Inventory responsibility.


BEGIN
fnd_global.apps_initialize(user_id => 1068,
resp_id => 21623, --Order Management Super User responsibility
resp_appl_id => 401);

IF fnd_function.test('HELLOWORLD') THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;


Output:False

If change resp_id to inventory ID,Output will be TRUE.


Check Oracle Application Developer Guide for API details(Chapter 11)


转载地址:https://blog.csdn.net/iteye_21199/article/details/82478694 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!

上一篇:Oracle AIM
下一篇:几种排序算法

发表评论

最新留言

哈哈,博客排版真的漂亮呢~
[***.172.111.71]2022年05月22日 09时03分58秒

关于作者

    喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!

最新文章