ITPub博客

首页 > IT基础架构 > 网络安全 > Views with the Prefix ALL (268)

Views with the Prefix ALL (268)

原创 网络安全 作者:tsinglee 时间:2007-11-28 10:58:34 0 删除 编辑

Views with the prefix ALL refer to the user’s overall perspective of the database. These
views return information about schema objects to which the user has access through
public or explicit grants of privileges and roles, in addition to schema objects that the
user owns. For example, the following query returns information about all the objects
to which you have access:
SELECT owner, object_name, object_type FROM ALL_OBJECTS;

ALL前缀视图
以 ALL为前缀的视图反映了某个用户所能看到的全部数据库内容。其中除了包含用户所拥有的方案对象之外,还包
含了用户可访问的公共对象,以及通过授予权限或角色而能够访问的方案对象

[@more@]

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

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