RE: Database Link Security et al
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