Does not work for me with 11.2.0.2 EE on Linux. FWIW. -joe SYS@qa1> select banner from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for Linux: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production SYS@qa1> connect jms Enter password: Connected. JMS@qa1> select name, userid, utl_raw.cast_to_varchar2(dbms_crypto.decrypt((substr(passwordx,19)), 4353, (substr(passwordx,3,16)))) passwd from ku$_dblink_view; select name, userid, utl_raw.cast_to_varchar2(dbms_crypto.decrypt((substr(passwordx,19)), 4353, (substr(passwordx,3,16)))) passwd from ku$_dblink_view * ERROR at line 1: ORA-00942: table or view does not exist JMS@qa1> connect / as sysdba Connected. SYS@qa1> grant dba to jms; Grant succeeded. SYS@qa1> connect jms Enter password: Connected. JMS@qa1> select name, userid, utl_raw.cast_to_varchar2(dbms_crypto.decrypt((substr(passwordx,19)), 4353, (substr(passwordx,3,16)))) passwd from ku$_dblink_view; select name, userid, utl_raw.cast_to_varchar2(dbms_crypto.decrypt((substr(passwordx,19)), 4353, (substr(passwordx,3,16)))) passwd from ku$_dblink_view * ERROR at line 1: ORA-00942: table or view does not exist JMS@qa1> connect / as sysdba Connected. SYS@qa1> revoke dba from jms; Revoke succeeded. SYS@qa1> -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Powell, Mark Sent: Wednesday, November 28, 2012 12:40 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Database Link Security et al On 10.2.0.5 (EE RAC) and 11.2.0.2.0 (Express) I get "ORA-00942: table or view does not exist" as a normal DBA privileged user (non-sysdba connection). From: rjamya [mailto:rjamya@xxxxxxxxx] Sent: Wednesday, November 28, 2012 2:26 PM To: Powell, Mark Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Database Link Security et al I was able to read the view as dba user in 11202. Raj On Wed, Nov 28, 2012 at 2:16 PM, Powell, Mark <mark.powell2@xxxxxx<mailto:mark.powell2@xxxxxx>> wrote: I was unable to read the ku$ view as a DBA so if you have to be a sysdba user to read the view how much of a problem is this really? -- //www.freelists.org/webpage/oracle-l Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you. -- //www.freelists.org/webpage/oracle-l