Re: create database link identified by values?
From: joel garry <joel-garry_at_home.com>
Date: Thu, 27 Aug 2009 10:26:07 -0700 (PDT)
Message-ID: <4d2b2143-85e2-4641-aab5-b7add3e88d35_at_d4g2000prc.googlegroups.com>
On Aug 27, 7:07 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "hehehe" <m..._at_m.ccc> a écrit dans le message de news: h763b0$1tn..._at_news2.ipartners.pl...
> | Hello!
> |
> | It`s possible? When a get from dba_users hash password id like to create
> | database link with this password like this :
> | create database link connect to 'test' identified by values '1234124213'
> | using 'test';
> |
> | But if i try its is possible but when i create new user
> |
> | create user test identified by values '2134123123231' profile wer;
> | its works
> |
> | regards - MJ
> |
> |
>
> No it is not possible.
>
> Regards
> Michel
Date: Thu, 27 Aug 2009 10:26:07 -0700 (PDT)
Message-ID: <4d2b2143-85e2-4641-aab5-b7add3e88d35_at_d4g2000prc.googlegroups.com>
On Aug 27, 7:07 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "hehehe" <m..._at_m.ccc> a écrit dans le message de news: h763b0$1tn..._at_news2.ipartners.pl...
> | Hello!
> |
> | It`s possible? When a get from dba_users hash password id like to create
> | database link with this password like this :
> | create database link connect to 'test' identified by values '1234124213'
> | using 'test';
> |
> | But if i try its is possible but when i create new user
> |
> | create user test identified by values '2134123123231' profile wer;
> | its works
> |
> | regards - MJ
> |
> |
>
> No it is not possible.
>
> Regards
> Michel
Not in dba_users, but if I grep for "DATABASE LINK" in a full rows=N export, I see something just like that, it is different than the user password on the linked db.
But...
select passwordx from KU$_DBLINK_VIEW;
Version dependent, I would guess.
jg
-- _at_home.com is bogus. Not only offensive, but isn't that a Mac...? http://www.cnn.com/2009/TECH/08/26/microsoft.ad.gaffe/index.html?iref=mpstoryviewReceived on Thu Aug 27 2009 - 12:26:07 CDT