怎样从dblink的设置中看到相关的用户密码？

Question

SELECT * FROM USER_DB_LINKS;可以直接看到当然模式下数据库链接用户名和密码等。

Answer 1

另外,用pl/sql dev工具.连接后.直接从左边的列表中找到db link,然后看属性,也可以的.

Answer 2

我建立的dblink是public的，public用户怎么登陆》？密码初始是什么啊 ？

Answer 3

no,can't~就算 select 到用户名和密码，密码也是用转换的形式表示出来~

Answer 4

dblink的密码在user_db_links中是明码存放的，自己去看看就知道了

Answer 5

1.当初建立的时候用:
  create public database link 'test' using 'test'; 
  来建立的话，也不可知道对方的用户的密码.   如建立时有写明的话，可在 user_db_links 查到.2. 默认的话，有scott/tiger, system/manager,sys/change_on_install

Answer 6

哈哈！终于找到了！用sys登陆，然后，里面有所有的东西
select *
from sys.link$ l, sys.user$ u
where l.owner# in ( select kzsrorol from x$kzsro )
  and l.owner# = u.user#

Answer 7

select *
from sys.link$ 就行

Answer 8

to  chanet(牧师），你写的那个建立databaselink的方法可行吗？测试结果：SQL> show user
User is "SYS"SQL> 
SQL> create public database link test using 'db92n1'
  2  ;Database link createdSQL> select * from dba_users@test;select * from dba_users@testORA-01005: null password given; logon deniedSQL> create public database link test1 connect to system identified by system using 'db92n1';Database link createdSQL> select * from dba_users@test1;USERNAME                          USER_ID PASSWORD                       ACCOUNT_STATUS                   LOCK_DATE   EXPIRY_DATE DEFAULT_TABLESPACE             TEMPORARY_TABLESPACE           CREATED     PROFILE                        INITIAL_RSRC_CONSUMER_GROUP    EXTERNAL_NAME
------------------------------ ---------- ------------------------------ -------------------------------- ----------- ----------- ------------------------------ ------------------------------ ----------- ------------------------------ ------------------------------ --------------------------------------------------------------------------------
SYS                                     0 E4FAE552BA8F0312               OPEN                                                     SYSTEM                         TEMP_1                         2004-5-24 1 DEFAULT                        SYS_GROUP                      
SYSTEM                                  5 970BAA5B81930A40               OPEN                                                     SYSTEM                         TEMP_1                         2004-5-24 1 DEFAULT                        SYS_GROUP                      
OUTLN                                  11 4A3BA55E08595C81               OPEN                                                     SYSTEM                         TEMP_1                         2004-5-24 1 DEFAULT                        DEFAULT_CONSUMER_GROUP         
DBSNMP                                 19 E066D214D5421CCC               OPEN                                                     SYSTEM                         TEMP_1                         2004-5-24 1 DEFAULT                        DEFAULT_CONSUMER_GROUP         
LIFANGJUN\LIFANGJUN                    44 EXTERNAL                       OPEN                                                     SYSTEM                         TEMP_1                         2004-5-28 1 DEFAULT                        DEFAULT_CONSUMER_GROUP         
GUEST2                                 53 EFBB14329F20F8C0               OPEN                                                     SYSTEM                         TEMP_1                         2004-9-9 14 DEFAULT                        DEFAULT_CONSUMER_GROUP         
CSMIG                                  45 09B4BB013FBD0D65               OPEN                                                     SYSTEM                         TEMP_1                         2004-6-21 1 DEFAULT                        DEFAULT_CONSUMER_GROUP         
GUEST1                                 46 C86CC6C6B78AC211               OPEN                                                     USERTBS                        TEMP_1                         2004-7-26 1 DEFAULT                        DEFAULT_CONSUMER_GROUP         
OMS                                    51 4BF4EB98E1BBA6D5               OPEN                                                     SPDATA                         TEMP_1                         2004-9-3 16 DEFAULT                        DEFAULT_CONSUMER_GROUP         
WMSYS                                  21 7C9BA362F8314299               EXPIRED & LOCKED                 2004-5-24 1             SYSTEM                         TEMP_1                         2004-5-24 1 DEFAULT                        DEFAULT_CONSUMER_GROUP         10 rows selectedSQL>

Answer 9

to drabit(square),可行~
前提是：A 数据库与 B 数据库连接的用户名和密码要相同.
如: select * from scott.emp@b;