Re: Seeing to much ...

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Fri, 09 Apr 1999 23:10:20 +0100
Message-ID: <370E7ACC.46E99337@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 Fri Apr 09 1999 - 17:10:20 CDT