ITPub博客

首页 > IT基础架构 > 网络安全 > Using Supplied Packages to Manage Stored Outlines

Using Supplied Packages to Manage Stored Outlines

原创 网络安全 作者:tsinglee 时间:2008-07-16 14:09:45 0 删除 编辑
The DBMS_OUTLN and DBMS_OUTLN_EDIT package provides procedures used for
managing stored outlines and their outline categories.
Users need the EXECUTE_CATALOG_ROLE role to execute DBMS_OUTLN, but public
has execute privileges on DBMS_OUTLN_EDIT. The DBMS_OUTLN_EDIT package is an
invoker's rights package.
Some of the useful DBMS_OUTLN and DBMS_OUTLN_EDIT procedures are:
■ CLEAR_USED - Clears specified outline
■ DROP_BY_CAT - Drops outlines that belong to a specified category
■ UPDATE_BY_CAT - Changes the category of outlines in one specified category to
a new specified category
■ EXACT_TEXT_SIGNATURES - Computes an outline signature according to an
exact text matching scheme
■ GENERATE_SIGNATURE - Generates a signature for the specified SQL text[@more@]

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

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