Re: Seeing to much ...

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au>
Date: Sat, 10 Apr 1999 23:20:56 +1000
Message-ID: <7enk0l$nqp$1@m2.c2.telstra-mm.net.au>

One trick is to replace the definition of "all_objects" by the definition of "user_objects". Ie, swap the views. It's easy, the text for both views is in the server. Cut and paste, add drop views where appropriate, rename the things and away you go: no more problems with MS-ODBC.

BTW, it's about bloody time MS fixed this problem!

--
Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au
http://www.acay.com.au/~nsouto/welcome.htm Christopher M. Day wrote in message <370E7ACC.46E99337_at_rdbms.freeserve.co.uk>...
>This is an implementation issue with MS-ODBC in which it queries
>all_objects, rather than user_objects. Check out the sql text in
>v$sqlarea.
>
>Chris
>
>"René" wrote:
>>
>> Hi there
>>
>> Our users want to use MS-ACCESS and connect on the database thru ODBC.
>> That works fine and performance is ok. But ...
>>
>> When the user connects to his schema, he sees not only his own objects
>> but a lot of other objects belonging to other users.
>>
>> And we don't want this: a user has to see only his objects.
>>
>> Any advice to solve this problem is welcome.
>>
>> Thanks
>>
>> René
>
Received on Sat Apr 10 1999 - 08:20:56 CDT