link$中明文存放了创建dblink的用户名和密码

Dblink创建后字典表dba_db_link中只保存创建连接时使用用户名，密码不保存，实际上在sys用户下的另一张字典表link$中保存了明文的用户密码，如果出现密码丢失或者不确认的情况，可以从中获取明文密码。

 

 

SQL> select * from link$ where name='CUSTOPR_BILL';

    OWNER# NAME                                                                                                                             CTIME
---------- -------------------------------------------------------------------------------------------------------------------------------- ---------
HOST
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
USERID                         PASSWORD                             FLAG AUTHUSR                        AUTHPWD
------------------------------ ------------------------------ ---------- ------------------------------ ------------------------------
        25 CUSTOPR_BILL                                                                                                                     21-DEC-06
BILL
ACCSNAP                        Q1W2E3R4                                0

SQL> quit

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/665930/viewspace-707675/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/665930/viewspace-707675/