Oracle权限(二)权限相关的动态性能视图与数据字典视图
发布日期:2021-08-25 00:12:13 浏览次数:1 分类:技术文章

本文共 5299 字,大约阅读时间需要 17 分钟。

001 DBA_USERS

DBA_USERS 描述了数据库中所有的用户信息。

相关视图:

USER_USERS 描述了当前用户的信息。该视图不包括 PASSWORDPROFILEPASSWORD_VERSIONSEDITIONS_ENABLED, 和AUTHENTICATION_TYPE 列.

Column Description
USERNAME 用户名
USER_ID 用户ID
PASSWORD 为了支持AUTHENTICATION_TYPE 列,该列已被弃用
ACCOUNT_STATUS 帐号(用户)状态,一共9种:
  • OPEN

  • EXPIRED

  • EXPIRED(GRACE)

  • LOCKED(TIMED)

  • LOCKED

  • EXPIRED & LOCKED(TIMED)

  • EXPIRED(GRACE) & LOCKED(TIMED)

  • EXPIRED & LOCKED

  • EXPIRED(GRACE) & LOCKED

LOCK_DATE 帐号被锁定的日期(如果帐号处于锁定状态)
EXPIRY_DATE 帐号过期的日期
DEFAULT_TABLESPACE 数据的默认表空间
TEMPORARY_TABLESPACE 默认的临时表空间名或临时表空间组名
CREATED 用户创建日期
PROFILE 用户资源概要文件名
INITIAL_RSRC_CONSUMER_GROUP 用户的初始资源消费者组
EXTERNAL_NAME 用户外部名
PASSWORD_VERSIONS Shows the list of versions of the password hashes (also known as "verifiers") existing for the account.

The PASSWORD_VERSIONS column value includes 10G if an old case-insensitive ORCL hash exists and 11G if a SHA-1 hash exists.

Note that one or both of these verifiers can exist for any given account.

EDITIONS_ENABLED Indicates whether editions have been enabled for the corresponding user (Y) or not (N)
AUTHENTICATION_TYPE Indicates the authentication mechanism for the user:
  • EXTERNAL - CREATE USER user1 IDENTIFIED EXTERNALLY;

  • GLOBAL - CREATE USER user2 IDENTIFIED GLOBALLY;

  • PASSWORD - CREATE USER user3 IDENTIFIED BY user3;

002 DBA_SYS_PRIVS

DBA_SYS_PRIVS 描述了授予给用户和角色的系统权限。

Column Description
GRANTEE Grantee name, user, or role receiving the grant
PRIVILEGE System privilege
ADMIN_OPTION Indicates whether the grant was with the ADMIN option (YES) or not (NO)
003 
ROLE_ROLE_PRIVS

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

Column Description
ROLE Name of the role
GRANTED_ROLE Role that was granted
ADMIN_OPTION Signifies that the role was granted with ADMIN option

004 ROLE_SYS_PRIVS

ROLE_SYS_PRIVS describes system privileges granted to roles. Information is provided only about roles to which the user has access.

Column Description
ROLE Name of the role
PRIVILEGE System privilege granted to the role
ADMIN_OPTION Indicates whether the grant was with the ADMIN option (YES) or not (NO)

005 ROLE_TAB_PRIVS

ROLE_TAB_PRIVS describes table privileges granted to roles. Information is provided only about roles to which the user has access.

Column Description
ROLE Name of the role
OWNER Owner of the object
TABLE_NAME Name of the object
COLUMN_NAME Name of the column, if applicable
PRIVILEGE Object privilege granted to the role
GRANTABLE YES if the role was granted with ADMIN OPTION; otherwise NO

 

006 DBA_TAB_PRIVS

DBA_TAB_PRIVS describes all object grants in the database.

Related View

USER_TAB_PRIVS describes the object grants for which the current user is the object owner, grantor, or grantee.

Column Description
GRANTEE Name of the user or role to whom access was granted
OWNER Owner of the object
TABLE_NAME Name of the object. The object can be any object, including tables, packages, indexes, sequences, and so on.
GRANTOR Name of the user who performed the grant
PRIVILEGE Privilege on the object
GRANTABLE Indicates whether the privilege was granted with the GRANT OPTION(YES) or not (NO)
HIERARCHY Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO)

007 DBA_COL_PRIVS

DBA_COL_PRIVS describes all column object grants in the database.

Related View

USER_COL_PRIVS describes the column object grants for which the current user is the object owner, grantor, or grantee.

Column Description
GRANTEE Name of the user or role to whom access was granted
OWNER Owner of the object
TABLE_NAME Name of the object
COLUMN_NAME Name of the column
GRANTOR Name of the user who performed the grant
PRIVILEGE Privilege on the column
GRANTABLE Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO)

008 DBA_ROLES

DBA_ROLES describes all roles in the database.

Column Description
ROLE Name of the role
PASSWORD_REQUIRED This column is deprecated in favor of the AUTHENTICATION_TYPEcolumn
AUTHENTICATION_TYPE Indicates the authentication mechanism for the role:
  • NONE - CREATE ROLE role1;

  • EXTERNAL - CREATE ROLE role2 IDENTIFIED EXTERNALLY;

  • GLOBAL - CREATE ROLE role3 IDENTIFIED GLOBALLY;

  • APPLICATION - CREATE ROLE role4 IDENTIFIED USINGschema.package;

  • PASSWORD - CREATE ROLE role5 IDENTIFIED BY role5;

009 DBA_ROLE_PRIVS

DBA_ROLE_PRIVS describes the roles granted to all users and roles in the database.

Related View

USER_ROLE_PRIVS describes the roles granted to the current user.

Column Description
GRANTEE Name of the user or role receiving the grant
GRANTED_ROLE Granted role name
ADMIN_OPTION Indicates whether the grant was with the ADMIN OPTION (YES) or not (NO)
DEFAULT_ROLE Indicates whether the role is designated as a DEFAULT ROLE for the user (YES) or not (NO)

010 V$PWFILE_USERS

V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBASYSOPER, and SYSASM privileges.

Column Description
USERNAME Name of the user that is contained in the password file
SYSDBA Indicates whether the user can connect with SYSDBA privileges (TRUE) or not (FALSE)
SYSOPER Indicates whether the user can connect with SYSOPER privileges (TRUE) or not (FALSE)
SYSASM Indicates whether the user can connect with SYSASM privileges (TRUE) or not (FALSE)

未完待续

转载地址:https://blog.csdn.net/weixin_33836223/article/details/90248343 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!

上一篇:JavaScript深入之词法作用域和动态作用域
下一篇:微信聊天和朋友圈可以拍摄和分享大视频?

发表评论

最新留言

初次前来,多多关照!
[***.217.46.12]2024年03月04日 14时41分14秒

关于作者

    喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!

推荐文章

python基础装饰器_Python基础 装饰器及练习 2019-04-21
python导出csv不带引号的句子_不带双引号写入CSV文件 2019-04-21
python爬虫代码模板_Python:学习Python爬虫的第一天 2019-04-21
springboot获取原生js请求_springboot跳转原生html 2019-04-21
java buffer nio_Java NIO之Buffer(缓冲区)入门 2019-04-21
android java加密_android 和java平台通用的AES加密解密 2019-04-21
java导出类_java导出excel工具类 2019-04-21
java学习手册下载_Java学习手册 2019-04-21
axios delete有请求体吗_关于axios请求——delete方法 2019-04-21
java 自助更改密码 api_搭建ldap自助修改密码系统--Self Service Password 2019-04-21
php继承exten,stylus中文文档 » 继承(@extend) » 张鑫旭-鑫空间-鑫生活 2019-04-21
mysql函数大全 pdf,MySQL函数大全 2019-04-21
php 常用文件系统函数,php 文件系统函数整理介绍 2019-04-21
android pm.java,java – AM / PM的Android DateFormat因设备而异 2019-04-21
oracle存储过程调用sql文件,oracle - 在SQL Developer中运行存储过程? 2019-04-21
oracle同时报604和12507,V$SES_OPTIMIZER_ENV 查不到刚修改的隐含参数, 2019-04-21
zblog的php更换域名,zblogphp更换域名后,原zblog里使用了固定域名,登录不进去怎么办... 2019-04-21
oracle dnfs 配置,Source of Oracle参数解析(dnfs_batch_size) - django-\/\/ i K | 2019-04-21
oracle所需的环境,转:面对一个全新的oracle环境,首先应该了解什么? 2019-04-21
linux 小数四则运行,shell四则运算(整数及浮点数)的方法介绍 2019-04-21