RE: Database Link Security et al

From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Wed, 28 Nov 2012 19:58:08 +0000
Message-ID: <D18D6513433DF04394041EA42B53E91C9CD7DF4A_at_ICATMAIL1.ICAT.com>



Does not work for me with 11.2.0.2 EE on Linux. FWIW.

-joe

SYS_at_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_at_qa1> connect jms
Enter password:
Connected.
JMS_at_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_at_qa1> connect / as sysdba
Connected.
SYS_at_qa1> grant dba to jms;

Grant succeeded.

SYS_at_qa1> connect jms
Enter password:
Connected.
JMS_at_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_at_qa1> connect / as sysdba
Connected.
SYS_at_qa1> revoke dba from jms;

Revoke succeeded.

SYS_at_qa1>
-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark Sent: Wednesday, November 28, 2012 12:40 PM To: oracle-l_at_freelists.org
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_at_gmail.com] Sent: Wednesday, November 28, 2012 2:26 PM To: Powell, Mark
Cc: oracle-l_at_freelists.org
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_at_hp.com<mailto:mark.powell2_at_hp.com>> 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?

--

http://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.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 28 2012 - 20:58:08 CET

Original text of this message