ITPub博客

首页 > IT基础架构 > 网络安全 > Management of Local Dependencies (251)

Management of Local Dependencies (251)

原创 网络安全 作者:tsinglee 时间:2007-11-26 17:22:15 0 删除 编辑

Oracle manages all local dependencies using the database’s internal dependency table,
which keeps track of each schema object’s dependent objects. When a referenced object
is modified, Oracle uses the depends-on table to identify dependent objects, which are
then invalidated.

For example, assume a stored procedure UPDATE_SAL references the table
JWARD.employees. If the definition of the table is altered in any way, the status of
every object that references JWARD.employees is changed to INVALID, including the
stored procedure UPDATE_SAL. As a result, the procedure cannot be run until it has
been recompiled and is valid. Similarly, when a DML privilege is revoked from a user,
every dependent object in the user’s schema is invalidated. However, an object that is
invalid because authorization was revoked can be revalidated by "reauthorization," in
which case it does not require full recompilation.

本地依赖性管理
1. Oracle 使用数据库内部的依赖关系表来管理所有的本地依赖性,依赖关系表用于记录每个方案对象的依赖对象
视图:user_dependencies

[@more@]

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

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892950