-
Doubt on DB Link Urgent
Can a Database link used to access only a single table
Plz asap
Pratheesh
-
database link
u can use databaselink to query a single table also
eg: select count(*) from emp@name_of_link;
-
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!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|