可能你不知的ORACLE秘密 系列一
日期：2014-05-16 浏览次数：20476 次
或许你不知的ORACLE秘密 系列一
Oracle 11g introduces Case-sensitive passwords for database authentication. Along with this if you wish to change the password (temporarily) and reset it back to old , you will find that password field in dba_users is empty. Prior to 11g we could use following technique to change/restore password
SQL> create user liu identified by liu;User created.
SQL> grant create session to liu;Grant succeeded.
SQL> conn sys as sysdbaEnter password:Connected.
SQL> select username,password from dba_users where username='LIU';
USERNAME PASSWORD
------------------------------ ------------------------------
LIU 9DEC0D889E8E9A6B
SQL> alter user amit identified by abc;
User altered.
SQL> conn amit/abc
Connected.
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> alter user LIU identified by values'9DEC0D889E8E9A6B';
User altered.
SQL> conn l
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
