DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Grant references........

  1. 11-28-2001, 08:52 PM #1
    osazee
    osazee is offline Junior Member
    Join Date
    Nov 2001
    Posts
    1
    Hi All,

    I am trying to GRANT REFERENCES on a table that resides on a different database on a different server. Is this possible and how do I go about doing that.

    TIA
    O.
    Reply With Quote Reply With Quote
  2. 11-28-2001, 09:40 PM #2
    Zaggy
    Zaggy is offline Member
    Join Date
    Apr 2001
    Posts
    219
    It should not be possible, becuase it relies on underlying system resources. These resources are not available the other database.

    ______________________
    Applications come and go,
    but the data remains!
    Reply With Quote Reply With Quote
  3. 11-29-2001, 01:06 AM #3
    Raminder's Avatar
    Raminder
    Raminder is offline Advisor
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    The problem can be solved by creating database link and global authentication. For further details you can refer Oracle documentation:

    http://otn.oracle.com/docs/products/...sers.htm#10662

    Raminder Singh
    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width