[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dbintegrator_public_public

Title:DB Integrator Public Conference
Notice:Database Integration - today! Kit/Doc info see note 36
Moderator:BROKE::ABUGOV
Created:Mon Sep 21 1992
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1171
Total number of notes:5187

1128.0. "change in behavior in dbi links & /user" by BROKE::BITHER () Tue Mar 04 1997 14:53

Hi,

In DBI v7 the following is true:

   When defining a dbi link to Oracle, the tables available to be 
   imported into Distributed Option are those owned by /user, 
   and NOT all the tables /user has access to.


In DBI 3.1A the following is true:

   When defining a dbi link to Oracle, the tables available to be 
   imported into Distributed Option are those owned by /user, AND
   those tables the user has access to.


I can't find a reference in the release notes re: this change in
behaviour.  Could someone verify that this is intentional behavior and
a reason for the change?

Thanks a lot, Diane
T.RTitleUserPersonal
Name		DateLines
1128.1sounds like a mistake...BROKE::ABUGOVTue Mar 04 1997 16:037
    
    Hi,
    
    I believe this is a regression from V3.1 behaviour, but I'll have to do
    more investigation to make sure.
    
    dan
1128.2I have met the enemy & it is meBROKE::GREENTue Mar 18 1997 15:4918
    No regression Dan.
    
    Last November when Diane and I were putting together the DBI class to
    be taught for support in the U.K. and Australia we had this same
    discussion.
    
    I had a DBI V3.1 link for Oracle user GREEN and another one for user
    SCOTT.  Back then I created a table using SQLPLUS and was surprised 
    when I imported the table into DBI from the other link, it worked.
    Well, what are the odds of user SCOTT having the same BEENIE_WEENIE
    table as user GREEN?  Get the picture?  User error.
    
    Accessing tables using just the gateway gives you access to all tables
    which you are allowed to access.  When you put DBI in front of the 
    gateway (relational gateway obviously) you can only import tables owned
    by the /USER on the link (no DBI proxy being used).
    
    Don
1128.3Thanks for the update...BROKE::ABUGOVWed Mar 19 1997 13:246
    
    Thanks for the update Don.  I looked at this briefly and it worked OK
    for me in gateway mode but I didn't get a chance yet to do a DBI based
    look.  Looks like I won't have to!
    
    dan