Database links

From: <midascs_at_my-deja.com>
Date: Wed, 27 Sep 2000 06:05:55 GMT
Message-ID: <8qs2o1$7hk$1@nnrp1.deja.com>

Hello.

I'm using oracle 8.0.6 on windows NT & HP-UNIX. My question is relating to database links.

Is there a type of database link available that enables users to call remote procedures and preserve the users session details ?

I understand that its possible to ommit the 'connect as' clause so that the user connects as 'themselves' over the link. However, we have a situation where the passwords differ across the instances, which makes this solution unworkable.

I aware that you can hard code the 'connect as' clause, but this looses the identity of the user on the remote instance. We need to keep track of this within packages on the remote server.

I guess what I'm looking for is a way for the db_link to connect to the remote database but allowing the user to identified as thier own connect id, so that when they execute the following statement : ' select user from dual ' on the remote machine it will return the username of the local machine and not the 'connect as' user defined in the database link.

I hope someone can explain if this is possible.

Regards
Mark

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 27 2000 - 01:05:55 CDT