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
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: 64152
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
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
Previous Topic: Application not coming up
Next Topic: can install two oracle version in one machine with two OS
Goto Forum:
  


Current Time: Sun Dec 11 00:27:25 CST 2016

Total time taken to generate the page: 0.08831 seconds