oracle11g 常用系统表整理

#1. dba_users;
describe dba_users;
名称 类型 是否为空值?
USERNAME VARCHAR2NOT NULL
USER_ID NUMBERNOT NULL
PASSWORD VARCHAR2
ACCOUNT_STATUS VARCHAR2NOT NULL
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE VARCHAR2NOT NULL
TEMPORARY_TABLESPACE VARCHAR2NOT NULL
CREATED DATE NOT NULL
PROFILE VARCHAR2NOT NULL
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2
EXTERNAL_NAME VARCHAR2
PASSWORD_VERSIONS VARCHAR2
EDITIONS_ENABLED VARCHAR2
AUTHENTICATION_TYPE VARCHAR2


SELECT * FROM dba_users where password=null;