使能及解锁oracle 内部用户
<br>SQL> select username, account_status from dba_users;<br><br>USERNAME ACCOUNT_STATUS<br>------------------------------ --------------------------------<br>SYS OPEN<br>SYSTEM OPEN<br>OUTLN EXPIRED & LOCKED<br>MGMT_VIEW EXPIRED & LOCKED<br>FLOWS_FILES EXPIRED & LOCKED<br>MDSYS EXPIRED & LOCKED<br>ORDSYS EXPIRED & LOCKED<br>EXFSYS EXPIRED & LOCKED<br>DBSNMP EXPIRED & LOCKED<br>WMSYS EXPIRED & LOCKED<br>APPQOSSYS EXPIRED & LOCKED<br><br>USERNAME ACCOUNT_STATUS<br>------------------------------ --------------------------------<br>APEX_030200 EXPIRED & LOCKED<br>OWBSYS_AUDIT EXPIRED & LOCKED<br>ORDDATA EXPIRED & LOCKED<br>CTXSYS EXPIRED & LOCKED<br>ANONYMOUS EXPIRED & LOCKED<br>SYSMAN EXPIRED & LOCKED<br>XDB EXPIRED & LOCKED<br>ORDPLUGINS EXPIRED & LOCKED<br>OWBSYS EXPIRED & LOCKED<br>SI_INFORMTN_SCHEMA EXPIRED & LOCKED<br>OLAPSYS EXPIRED & LOCKED<br><br>USERNAME ACCOUNT_STATUS<br>------------------------------ --------------------------------<br>SCOTT EXPIRED & LOCKED<br>ORACLE_OCM EXPIRED & LOCKED<br>XS$NULL EXPIRED & LOCKED<br>BI EXPIRED & LOCKED<br>PM EXPIRED & LOCKED<br>MDDATA EXPIRED & LOCKED<br>IX EXPIRED & LOCKED<br>SH EXPIRED & LOCKED<br>DIP EXPIRED & LOCKED<br>OE EXPIRED & LOCKED<br>APEX_PUBLIC_USER EXPIRED & LOCKED<br><br>USERNAME ACCOUNT_STATUS<br>------------------------------ --------------------------------<br>HR EXPIRED & LOCKED<br>SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED<br>SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED<br><br>36 rows selected.<br><br><br>SQL> alter user scott account unlock;<br><br>User altered.<br><br><br>SQL> alter user scott identified by tiger;<br><br>User altered.<br><br>SQL> <br><br><br>注释:<br>oracle 的用户信息都在dba_users表中,<br>默认只有sys、和sysdba 两个用户是open的,<br>alter user scott account unlock; 这个命令是给scott用户解锁,<br>alter user scott identified by tiger; 这个命令是给scott用户设置密码,<br>通过这两个语句,scott 用户就可以使用了。<br>其它用户同理可用。<br>
页:
[1]