RE: Database Link Security et al
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: "mark.powell2@xxxxxx" <mark.powell2@xxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Nov 2012 19:58:08 +0000
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
Other related posts:
