Re: Dblink in Oracle10g

From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 19 Nov 2008 15:46:21 -0600 (CST)

I *knew* there had to be a valid reason for me to use proxies.  Guess I have
something to play with now.

Thanks,
Rich

> Instead of tampering with passwords and profiles it's safer to use proxy
> authentication like:
>
> SQL> drop user u1 cascade;
> User dropped.
> SQL> drop user u2 cascade;
> User dropped.
> SQL> create user u1 identified by u1;
> User created.
> SQL> grant create session, create database link to u1;
> Grant succeeded.
> SQL> create user u2 identified by u2;
> User created.
> SQL> grant create session to u2;
> Grant succeeded.
> SQL> alter user u1 grant connect through u2;
> User altered.
> SQL> connect u2[u1]/u2
> Connected.
> SQL> show user
> USER is "U1"
> SQL> create database link a connect to b identified by c using 'd';
> Database link created.
> SQL>
>
> --romas


--
http://www.freelists.org/webpage/oracle-l

References:

Re: Dblink in Oracle10g
From: Rich Jesse

RE: Dblink in Oracle10g
From: Joel.Patterson

Re: Dblink in Oracle10g
From: Jared Still

Re: Dblink in Oracle10g
From: Roman Podshivalov

Re: Dblink in Oracle10g

Other related posts: