Oracle Security API - FND_FUCTION.TEST

最新推荐文章于 2021-04-03 12:57:14 发布

田攀

最新推荐文章于 2021-04-03 12:57:14 发布

阅读量3.5k

点赞数

本文链接：https://blog.csdn.net/pan_tian/article/details/8595711

版权

本文详细介绍了Oracle Security API中的FND_FUCTION.TEST函数，该函数用于检查在当前责任下是否可以访问指定函数。尽管它仅检查静态函数安全性和全局对象类型的权限，不适用于包含对象ID和实例主键的数据安全性测试，但在性能关键场景和向后兼容性方面仍有其价值。建议在处理特定对象实例时使用TEST_INSTANCE代替。通过示例演示了如何使用此函数，并提示读者查阅Oracle应用开发者指南第11章获取更多信息。

摘要由CSDN通过智能技术生成

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