OraFAQ Forum: Server Administration » db

Home » RDBMS Server » Server Administration » db_link limit access

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

db_link limit access [message #540017]

Thu, 19 January 2012 13:39

BeefStu
Messages: 208
Registered: October 2011

Senior Member

I need to create a db_link but limit access to that db_link
to specific users. Can somebody provide me with some guidance
on the best way to create the link and provide access.

Report message to a moderator

Re: db_link limit access [message #540018 is a reply to message #540017]

Thu, 19 January 2012 13:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

make private DB link for specific users

Report message to a moderator

Re: db_link limit access [message #540022 is a reply to message #540018]

Thu, 19 January 2012 14:01

John Watson
Messages: 8996
Registered: January 2010
Location: Global Village

Senior Member

I reckon best practice is to create a public link with the connect string, and have your users create private links with their own login details (which you don't have to know). That way you control the network, and they are responsible for their own security. Like this:

conn system/manager
create public database link l1 using '127.0.0.1:1521/orcl';
connect scott/****;
create database link l1 connect to scott identified by ****;

Report message to a moderator

Re: db_link limit access [message #540044 is a reply to message #540022]

Thu, 19 January 2012 22:35

BeefStu
Messages: 208
Registered: October 2011

Senior Member

John,

Thanks, I gave the users create database link perms and let them create thier own link.

Report message to a moderator

Previous Topic:	SCN max value (was: Oracle flaw revealed ?)
Next Topic:	oracle tracing at stop and start

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 04 00:45:06 CST 2026