查询dblink的user 密码,用sys 登陆
SELECT * FROM SYS.link$;
SELECT *
FROM SYS.link$ l, SYS.user$ u
WHERE l.owner# IN (SELECT kzsrorol
FROM x$kzsro) AND l.owner# = u.user#;
如果是private 的dblink,就可以用owner登录,查询 user_db_links
Select * from user_db_links;
查询dblink的user 密码,用sys 登陆
SELECT * FROM SYS.link$;
SELECT *
FROM SYS.link$ l, SYS.user$ u
WHERE l.owner# IN (SELECT kzsrorol
FROM x$kzsro) AND l.owner# = u.user#;
如果是private 的dblink,就可以用owner登录,查询 user_db_links
Select * from user_db_links;
转载于:https://www.cnblogs.com/yifan268/archive/2008/09/26/1299636.html