Home » RDBMS Server » Server Administration » DBLINK Query (10G , Unix)
icon7.gif  DBLINK Query [message #346411] Mon, 08 September 2008 08:18 Go to next message
saagar
Messages: 79
Registered: December 2007
Member
Dear all

i have a query on DBLINK

one of my database x on xyz environment

another DB y on abc environment

now i want to give access to user1 who is in abc environment to my database x on xyz environment ...that i can achieve by DBLINK
but if i want to restrict this user1 only to give select grant on x DB is it possible bcos user1 will be accessing my DB x via DBLINK...please correct me if i am wrong......

thanking you in advance
CHeers

Report message to a moderator

Re: DBLINK Query [message #346416 is a reply to message #346411] Mon, 08 September 2008 08:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just use a user that has read only access in your db link.

Regards
Michel

Report message to a moderator

Re: DBLINK Query [message #346579 is a reply to message #346416] Mon, 08 September 2008 23:38 Go to previous message
saagar
Messages: 79
Registered: December 2007
Member
ok

thank you micheal.........

CHeers

Report message to a moderator

Previous Topic: Application not coming up
Next Topic: can install two oracle version in one machine with two OS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 05:33:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.