系统用户
sysman：
密码是安装数据库时设置。
scott：
密码是tiger。
[username/password][@server][as sysdba|sysoper]
举例：system/root @orcl as sysdba
解释：orcl就是自己设置得服务名
实例：
show user命令
dba_users数据字典
请输入用户名: system输入口令:连接到:OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProductionWith the Partitioning, OLAP,DataMiningandRealApplicationTesting optionssql> show userUSER 为"SYSTEM"sql> desc dba_users名称是否为空?类型-----------------------------------------------------------------------------USERNAME NOT NULL VARCHAR2(30)USER_ID NOT NULL NUMBERPASSWORD VARCHAR2(30)ACCOUNT_STATUS NOT NULL VARCHAR2(32)LOCK_DATE DATEEXPIRY_DATE DATEDEFAULT_TABLESPACE NOT NULL VARCHAR2(30)TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30)CREATED NOT NULL DATEPROFILE NOT NULL VARCHAR2(30)INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)EXTERNAL_NAME VARCHAR2(4000)PASSWORD_VERSIONS VARCHAR2(8)EDITIONS_ENABLED VARCHAR2(1)AUTHENTICATION_TYPE VARCHAR2(8)sql>select username from dba_users;USERNAME------------------------------MGMT_VIEWSYSSYSTEMDBSNMPSYSMANOUTLNFLOWS_FILESMDSYSORDSYSEXFSYSWMSYSUSERNAME------------------------------APPQOSSYSAPEX_030200OWBSYS_AUDITORDDATACTXSYSANONYMOUSXDBORDPLUGINSOWBSYSSI_INFORMTN_SCHEMAOLAPSYSUSERNAME------------------------------SCOTTORACLE_OCMXS$NULLBIPMMDDATAIXSHDIPOEAPEX_PUBLIC_USERUSERNAME------------------------------HRSPATIAL_CSW_ADMIN_USRSPATIAL_WFS_ADMIN_USR已选择36行。
启用用户的语句
ater user username account unlock
