ITPub博客

首页 > 数据库 > Oracle > Oracle Security API - FND_FUCTION.TEST

Oracle Security API - FND_FUCTION.TEST

原创 Oracle 作者:pan_tian 时间:2014-07-02 16:33:14 0 删除 编辑

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)


<!-- Baidu Button BEGIN -->

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26687597/viewspace-1204923/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: Top 10 Free Ways of Securing Your EBS Instance
下一篇: Oracle AIM
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2012-02-18

最新文章