Oracle权限（二）权限相关的动态性能视图与数据字典视图

001 DBA_USERS

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

相关视图：

USER_USERS 描述了当前用户的信息。该视图不包括 PASSWORD, PROFILE, PASSWORD_VERSIONS, EDITIONS_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 SYSDBA, SYSOPER, 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)

未完待续

时间： 2024-08-22 14:06:43

Oracle权限（二）权限相关的动态性能视图与数据字典视图的相关文章

Oracle给普通用户赋予查询动态性能视图的权限

给普通用户赋予查询动态性能视图的权限时,动态性能视图的名字不能像是平常那种写法V$,而是应写成V_$:

oracle最重要的9个动态性能视图

v$session + v$session_wait (在10g里功能被整合,凑合算1个吧.) v$process v$sql v$sqltext v$bh (更宁愿是x$bh) v$lock v$latch_children v$sysstat v$system_event 按组分的几组重要的性能视图 1.System 的 over view v$sysstat , v$system_event , v$parameter 2.某个session 的当前情况 v$process , v$ses

OCP1z0-047 :基本概念：同义词、动态性能视图、数据字典视图

答案A是对的,来自己官方的解释: USER_SYNONYMS USER_SYNONYMS describes theprivate synonyms (synonyms owned by the current user). Its columns () are thesame as those in ALL_SYNONYMS. 测试如下:创建两个同义词:一个是公共的,一个是私有的,然后再查询 gyj@OCM> createsynonym emp1 for hr.employees; Synon

Oracle 数据字典视图(V$,GV$,X$) #

1.常用的几个数据字典: user_objects : 记录了用户的所有对象,包含表.索引.过程.视图等信息,以及创建时间,状态是否有效等信息,是非DBA用户的大本营.想知道自己有哪些对象,往这里查. user_source :包含了系统中对象的原码,如存储过程,FUNCTION.PROCEDURE.PACKAGE等信息 cat或Tab :包含当前用户所有的用户和视图信息和同义词信息,cat还多了一个SYNONYM; dict :系统中所有的数据字典都存储在这里面  Oracle中的数据字典有静

Oracle 数据字典和数据字典视图

--============================== --Oracle 数据字典和数据字典视图 --==============================   数据字典     是元数据的集合,从逻辑上和物理上描述了数据库及内容,存储于SYSTEM与SYSAUX表空间内的若干段.     SYS用户拥有所有的数据字典表,数据字典基本一般以$结尾,如col$,tab$等,这些数据字典存放在system表空间中.     数据字典的形成     在数据库创建阶段创建,在使用阶段维护

Oracle角色、权限、用户相关知识

Oracle内置角色connect与resource的权限  首先用一个命令赋予user用户connect角色和resource角色:  grant connect,resource to user;  运行成功后用户包括的权限:  CONNECT角色: --是授予最终用户的典型权利,最基本的  ALTER SESSION --修改会话  CREATE CLUSTER --建立聚簇  CREATE DATABASE LINK --建立数据库链接  CREATE SEQUENCE --建立序列 

通过Oracle动态性能视图采集查询调优数

对于现在的一些发行版本,DBA(Database Administrator,数据库管理员)和开发员可以访问的已经有三种动态性能视图了,分别为V$SQL.V$SQLAREA,还有V$SQLTEXT. 这些视图可以用来采集有关SQL命令执行的统计信息.在Oracle 10g, Release 2中,还增加了第四个动态性能视图,V$SQLSTATS,通过它能更方便地访问这类数据. 和静态数据字典视图(static dictionary view,也就是前缀为USER_.ALL_,或者DBA_的视图)

Oracle的对象权限、角色权限、系统权限

Oracle的对象权限.角色权限.系统权限 一.用户与模式     用户:对数据库的访问,需要以适当用户身份通过验证,并具有相关权限来完成一系列动作        SYS用户,缺省始终创建,且未被锁定,拥有数据字典及其关联的所有对象        SYSTEM用户,缺省始终创建,且未被锁定,可以访问数据库内的所有对象     模式(schema):是某个用户拥有所有对象的集合.具有创建对象权限并创建了对象的用户称为拥有某个模式       注意:创建数据库对象(视图,表等)的任一用户都拥有一个以

Oracle角色及权限详解

一.Oracle内置角色connect与resource的权限 grant connect,resource to user; CONNECT角色: --是授予最终用户的典型权利,最基本的 ALTER SESSION --修改会话 CREATE CLUSTER --建立聚簇 CREATE DATABASE LINK --建立数据库链接 CREATE SEQUENCE --建立序列 CREATE SESSION --建立会话 CREATE SYNONYM --建立同义词 CREATE VIEW -