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

Thread: Doubt on DB Link Urgent

  1. #1
    Join Date
    Oct 2002
    Posts
    43

    Red face Doubt on DB Link Urgent

    Can a Database link used to access only a single table
    Plz asap
    Pratheesh

  2. #2
    Join Date
    Oct 2002
    Location
    Bangalore,India
    Posts
    32

    database link

    u can use databaselink to query a single table also

    eg: select count(*) from emp@name_of_link;

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    I assume you want the link to be able to access only one table out of a schema, if so then simply create a new user with access only to that one table and create the link using that user.

    eg

    USERA has tables EMP, DEPT, SAL
    USERB has SELECT access granted on USERA.EMP

    Connect using USERB on the link definition.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Oct 2002
    Posts
    43

    Re: database link

    Originally posted by tharakab
    u can use databaselink to query a single table also

    eg: select count(*) from emp@name_of_link;
    No yaar, Should be restrict to access a single table

Posting Permissions

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


Click Here to Expand Forum to Full Width