| Grant the rights to other database user [message #9467] |
Wed, 12 November 2003 21:52  |
Imran Khan
Messages: 6
Registered: May 2002
|
Junior Member |
|
|
|
I have two databases (orc1 , orc2) and I created the service and db link of ora1 database in orc2. Now I want to give some object privileges orc1 from orc2 plz tell me the syntax and proper way - thanks
|
|
|
|
| Re: Grant the rights to other database user [message #9479 is a reply to message #9467] |
Fri, 14 November 2003 05:09  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Create a local user with the appropriate privileges(& synonyms) on the tables of interest.
Create database link on the remote node to connect to the local database through this user.
Use the database link on the remote node to access the tables . It controls the privileges now.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
