ITPub博客

首页 > 数据库 > Oracle > 关于oracle用户权限查询总结视图

关于oracle用户权限查询总结视图

原创 Oracle 作者:流浪的野狼 时间:2014-01-07 17:18:44 0 删除 编辑

一直在学习oracle官方文档,今天抽空全面学习了下oracle权限与角色这一方面,感觉下面的内容对很多关心oracle安全性的同仁或许有所帮助,下述内容整理自oracle官方文档:
 

View

Description

ALL_COL_PRIVS

Describes all column object grants for which the current user or PUBLIC is the object owner, grantor, or grantee

ALL_COL_PRIVS_MADE

Lists column object grants for which the current user is object owner or grantor.

ALL_COL_PRIVS_RECD

Describes column object grants for which the current user or PUBLIC is the grantee

ALL_TAB_PRIVS

Lists the grants on objects where the user or PUBLIC is the grantee

ALL_TAB_PRIVS_MADE

Lists the all object grants made by the current user or made on the objects owned by the current user.

ALL_TAB_PRIVS_RECD

Lists object grants for which the user or PUBLIC is the grantee

DBA_COL_PRIVS

Describes all column object grants in the database

DBA_TAB_PRIVS

Lists all grants on all objects in the database

DBA_ROLES

This view lists all roles that exist in the database, including secure application roles. Note that it does not list the PUBLICrole.

DBA_ROLE_PRIVS

Lists roles granted to users and roles

DBA_SYS_PRIVS

Lists system privileges granted to users and roles

SESSION_PRIVS

Lists the privileges that are currently enabled for the user

SESSION_ROLES

Lists all roles that are enabled for the current user. Note that it does not list the PUBLIC role.

ROLE_ROLE_PRIVS

This view describes roles granted to other roles. Information is provided only about roles to which the user has access.

ROLE_SYS_PRIVS

This view contains information about system privileges granted to roles. Information is provided only about roles to which the user has access.

ROLE_TAB_PRIVS

This view contains information about object privileges granted to roles. Information is provided only about roles to which the user has access.

USER_COL_PRIVS

Describes column object grants for which the current user is the object owner, grantor, or grantee

USER_COL_PRIVS_MADE

Describes column object grants for which the current user is the grantor

USER_COL_PRIVS_RECD

Describes column object grants for which the current user is the grantee

USER_ROLE_PRIVS

Lists roles granted to the current user

USER_TAB_PRIVS

Lists grants on all objects where the current user is the grantee

USER_SYS_PRIVS

Lists system privileges granted to the current user

USER_TAB_PRIVS_MADE

Lists grants on all objects owned by the object owner

USER_TAB_PRIVS_RECD

Lists object grants for which the current user is the grantee

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

下一篇: ORA-00600错误分析
请登录后发表评论 登录
全部评论

注册时间:2013-04-10

  • 博文量
    151
  • 访问量
    1600470