Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: password and dblink mgmt tool

RE: password and dblink mgmt tool

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Thu, 03 Mar 2005 22:28:14 +0800
Message-Id: <6.2.0.14.0.20050303222559.041095a8@pop.singnet.com.sg>

My database "users" are actually Application Schemas. End-users do not have database accounts.
Database Links are requested by the Application Teams to "connect" two databases running
different applications. Neither do I have the same username nor do I expect the same username
present in the two databases. I setup a specific account with privileges only on a subset
of tables/objects in the remote database to be used for the DBLink.

Hemant
At 09:57 AM Thursday, Hollis, Les wrote:
>You don't use a userid/password
>
>Create public database link PROD using 'PROD';
>
>
>
>If the user exists on source database and the destination database, then
>statements will work. If user id does not match across DB's then they
>don't have any perms.
>
>Access to tables can be granted just like in the same DB. Grant select,
>insert on tablename to username. Etc
>

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 03 2005 - 09:36:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US