| Granting object privileges to remote users [message #360352] |
Thu, 20 November 2008 10:47  |
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
|
Senior Member |
|
|
Hello,
Here's the situation:
I have 2 databases located on 2 different servers both running Win2k3. In the first database the main schema is M1 and it has to read objects on the another schema M2, located on the second database.
I created a database link on the first database, to point to the second database
create database link connect2M2db connect to M2 identified by M2 using 'connect2M2db'
Now I would like to grant object privileges(insert,update,delete) to M1 on M2' objects. How do I do that?
Thanks.
|
|
|
|
|
|
| Re: Granting object privileges to remote users [message #360360 is a reply to message #360355] |
Thu, 20 November 2008 11:29  |
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
|
Senior Member |
|
|
| Michel Cadot wrote on Thu, 20 November 2008 10:57 | M1 inherites the privileges on the remote database of the user it connects through the database link.
Regards
Michel
|
Does it mean that we don't need to explicitly grant insert,update and delete privileges to M1 from M2's schema?
|
|
|
|
|
|
|
|
| Re: Granting object privileges to remote users [message #360492 is a reply to message #360468] |
Fri, 21 November 2008 03:00 |
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
|
Senior Member |
|
|
hmmm, there's one thing I forgot to say: synonyms for tables belonging to M2 were created on M1. But whenever we try to manipulate those synonyms on M1, we get the error:
ora 04045 :error during recompilation/revalidation of M1.Job, and ora 00980: Synonym translation is no longer valid.
I made a search and I got a solution for the ora 04045 (ref post #73745) on this forum, but am afraid it does not apply to my case.
As for the ora 00980, the actual tables are located on a remote database (M2), and both the databases are linked through a databse link.
Any tips?
[Updated on: Fri, 21 November 2008 03:52] Report message to a moderator |
|
|
|
|
|
| Re: Granting object privileges to remote users [message #360528 is a reply to message #360521] |
Fri, 21 November 2008 05:00 |
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
|
Senior Member |
|
|
Uhum...Well I just reviewed the command used to create the synonyms and I realized that the database link was not added to those commands. Here's an example:
create or replace synonym job for m2.job
I got the idea from a post I found here (message #225847) which was a reply to similar problem. As I have a database link, it suggests to create the synonym as follow:
create or replace synonym job for m2.job@connect2M2db
I guest that syntax is correct, isn't it?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
