熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

oracle修改用戶登錄密碼

2013-11-13 22:24:54  來源: Oracle 

  使用oracle用戶登錄連接數據庫

  [oracle@wuzj ~]$ sqlplus /nolog

  SQL*Plus: Release Production on Thu Feb ::

  Copyright (c) Oracle All rights reserved

  SQL> conn /as sysdba

  Connected

  //查看用戶

  SQL> select usernamepassword from dba_users;

  USERNAME PASSWORD

  

  USER BBEAF

  MGMT_VIEW FDFFF

  SYS AFAA

  SYSTEM BAABA

  DBSNMP FFFBBCCEC

  SYSMAN CAFFCCC

  OUTLN ABAEC

  MDSYS ABADAF

  ORDSYS EFAECEABF

  EXFSYS FEFC

  DMSYS BFBAAFDEA

  USERNAME PASSWORD

  

  WMSYS CBAF

  CTXSYS EFADE

  ANONYMOUS anonymous

  XDB DFCEAF

  ORDPLUGINS ABCF

  SI_INFORMTN_SCHEMA BCBCADFA

  OLAPSYS FBEFDBC

  SCOTT FCB

  TSMSYS DFABDFF

  BI FADBBF

  PM EAEA

  USERNAME PASSWORD

  

  MDDATA DFADEE

  IX BEFEFEB

  SH BCDBDA

  DIP CEABECAC

  OE CEECBD

  HR FBEDF

   rows selected

  //修改用戶口令 格式 alter user 用戶名 identified by 新密碼;

  SQL> alter user system identified by manager;

  User altered

  //再次查看對比發現密碼已經更換

  SQL> select usernamepassword from dba_users;

  USERNAME PASSWORD

  

  USER BBEAF

  MGMT_VIEW FDFFF

  SYS AFAA

  SYSTEM DDFABE

  DBSNMP FFFBBCCEC

  SYSMAN CAFFCCC

  OUTLN ABAEC

  MDSYS ABADAF

  ORDSYS EFAECEABF

  EXFSYS FEFC

  DMSYS BFBAAFDEA

  USERNAME PASSWORD

  

  WMSYS CBAF

  CTXSYS EFADE

  ANONYMOUS anonymous

  XDB DFCEAF

  ORDPLUGINS ABCF

  SI_INFORMTN_SCHEMA BCBCADFA

  OLAPSYS FBEFDBC

  SCOTT FCB

  TSMSYS DFABDFF

  BI FADBBF

  PM EAEA

  USERNAME PASSWORD

  

  MDDATA DFADEE

  IX BEFEFEB

  SH BCDBDA

  DIP CEABECAC

  OE CEECBD

  HR FBEDF

   rows selected

  SQL>

  //現在就可以用此密碼鏈接進行操作了

  SQL> connect system/manager

  已連接

  ==========================

  另一種修改值的辦法

  SQL> alter user system identified by values DEFBA;

  用戶已更改

  //在試試這個密碼

  SQL> connect system/oracle

  已連接

  //這個密碼就不靈了

  SQL> connect system/manager

  ERROR:

  ORA: invalid username/password; logon denied


From:http://tw.wingwit.com/Article/program/Oracle/201311/19044.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.