I haven't done it with the REFERENCES privilige but with others the
following will work:
1. create the same user account with the same password in the other
database.
2. grant the appropriate permissions to that user.
3. refer to the table with @servicename or create a synonym with the
@service
Thanks for your reply Paul.
Would you be kind enough to elaborate on the 3rd point. I thought I
followed but what I implemented gave me this error
ORA-02021: DDL operations are not allowed on a remote database.
Any pointers would be most appreciated.
- Original Message -
To: "Multiple
What SQL or PL/SQL are you trying to run?
-Original Message-
Sent: Thursday, November 29, 2001 12:53 PM
To: Multiple recipients of list ORACLE-L
Thanks for your reply Paul.
Would you be kind enough to elaborate on the 3rd point. I thought I
followed but what I implemented gave me th
Title: RE: GRANT REFERENCES
Oracle itself saying that, you cann't create foreign key for a remote database table.
To achive this, use database triggers.
Let me know if am wrong?
Nirmal.
-Original Message-
From: Ekan Emokpae [SMTP:[EMAIL PROTECTED]]
Sent: Thu