18.Oracle杂记——数据字典dba_users

18.Oracle杂记——数据字典dba_users

视图dba_users:关于数据的所有用户的信息

                  描述如下：

sys@PDB1> desc dba_users;

 Name                                                                                                     Null?         Type

 ------------------------------------------------------------- ------------------------------------

 USERNAME                                                                                         NOT NULL VARCHAR2(128)

 USER_ID                                                                                               NOT NULL NUMBER

 PASSWORD                                                                                                                      VARCHAR2(4000)

 ACCOUNT_STATUS                                                                         NOT NULL VARCHAR2(32)

 LOCK_DATE                                                                                                                      DATE

 EXPIRY_DATE                                                                                                                  DATE

 DEFAULT_TABLESPACE                                                                  NOT NULL VARCHAR2(30)

 TEMPORARY_TABLESPACE                                                                             NOT NULL VARCHAR2(30)

 CREATED                                                                                              NOT NULL DATE

 PROFILE                                                                                                NOT NULL VARCHAR2(128)

 INITIAL_RSRC_CONSUMER_GROUP                                                                                         VARCHAR2(128)

 EXTERNAL_NAME                                                                                                                            VARCHAR2(4000)

 PASSWORD_VERSIONS                                                                                              VARCHAR2(12)

 EDITIONS_ENABLED                                                                                                     VARCHAR2(1)

 AUTHENTICATION_TYPE                                                                                            VARCHAR2(8)

 PROXY_ONLY_CONNECT                                                                                             VARCHAR2(1)

 COMMON                                                                                                                       VARCHAR2(3)

 LAST_LOGIN                                                                                                                    TIMESTAMP(9)WITH TIME ZONE

 ORACLE_MAINTAINED                                                                                                VARCHAR2(1)

列各个属性介绍如下：

USERNAME：用户名字

 USER_ID：用户ID

 PASSWORD：用户密码

 ACCOUNT_STATUS：账号状态

 LOCK_DATE：状态状态是否锁住

 EXPIRY_DATE      ：账号过期时间

 DEFAULT_TABLESPACE：默认表空间

 TEMPORARY_TABLESPACE：默认临时表空间

 CREATED：创建时间

 PROFILE                 ：资源配置文件

 INITIAL_RSRC_CONSUMER_GROUP：用户初始资源消耗组

 EXTERNAL_NAME：用户外部名字

 PASSWORD_VERSIONS    ：密码哈希值的使用版本

 EDITIONS_ENABLED：用户版本是否使能

 AUTHENTICATION_TYPE:用户认证机制

 PROXY_ONLY_CONNECT: 是否直接连接还是需要通过代理

 COMMON： 给的用户是否是通用的。

 LAST_LOGIN:最后一次登录

 ORACLE_MAINTAINED:用户是否是通过catalog.sql或catproc.sql创建的。