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

001DBA_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.

ThePASSWORD_VERSIONScolumn value includes10Gif an old case-insensitive ORCL hash exists and11Gif 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 USERuser1IDENTIFIED EXTERNALLY;

GLOBAL-CREATE USERuser2IDENTIFIED GLOBALLY;

PASSWORD-CREATE USERuser3IDENTIFIED BYuser3;

002DBA_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 theADMINoption (YES) or not (NO)

003ROLE_ROLE_PRIVS

ROLE_ROLE_PRIVSdescribes 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 withADMINoption

004ROLE_SYS_PRIVS

ROLE_SYS_PRIVSdescribes 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 theADMINoption (YES) or not (NO)

005ROLE_TAB_PRIVS

ROLE_TAB_PRIVSdescribes 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

YESif the role was granted withADMIN OPTION; otherwiseNO

006DBA_TAB_PRIVS

DBA_TAB_PRIVSdescribes all object grants in the database.

Related View

USER_TAB_PRIVSdescribes 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 theGRANT OPTION(YES) or not (NO)

HIERARCHY

Indicates whether the privilege was granted with theHIERARCHY OPTION(YES) or not (NO)

007DBA_COL_PRIVS

DBA_COL_PRIVSdescribes all column object grants in the database.

Related View

USER_COL_PRIVSdescribes 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 theGRANT OPTION(YES) or not (NO)

008DBA_ROLES

DBA_ROLESdescribes all roles in the database.

Column

Description

ROLE

Name of the role

PASSWORD_REQUIRED

This column is deprecated in favor of theAUTHENTICATION_TYPEcolumn

AUTHENTICATION_TYPE

Indicates the authentication mechanism for the role:

NONE-CREATE ROLErole1;

EXTERNAL-CREATE ROLErole2IDENTIFIED EXTERNALLY;

GLOBAL-CREATE ROLErole3IDENTIFIED GLOBALLY;

APPLICATION-CREATE ROLErole4IDENTIFIED USINGschema.package;

PASSWORD-CREATE ROLErole5IDENTIFIED BYrole5;

009DBA_ROLE_PRIVS

DBA_ROLE_PRIVSdescribes the roles granted to all users and roles in the database.

Related View

USER_ROLE_PRIVSdescribes 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 theADMIN OPTION(YES) or not (NO)

DEFAULT_ROLE

Indicates whether the role is designated as aDEFAULT ROLEfor the user (YES) or not (NO)

010V$PWFILE_USERS

V$PWFILE_USERSlists all users in the password file, and indicates whether the user has been granted theSYSDBA,SYSOPER, andSYSASMprivileges.

Column

Description

USERNAME

Name of the user that is contained in the password file

SYSDBA

Indicates whether the user can connect withSYSDBAprivileges (TRUE) or not (FALSE)

SYSOPER

Indicates whether the user can connect withSYSOPERprivileges (TRUE) or not (FALSE)

SYSASM

Indicates whether the user can connect withSYSASMprivileges (TRUE) or not (FALSE)

未完待续