Re: Setting ODBC user priveleges

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 11 Mar 2001 06:30:42 -0800
Message-ID: <3AAB8C12.5F827A3E@exesolutions.com>

> When I use ODBC to link to an Oracle database (say through MS Access), I can
> see all schemas/objects in the instance. How can I restrict my Oracle
> configuration so ODBC users see only the objects in one (or more) schemas?
>
> I've been messing around with GRANTing and REVOKEing the PRIVELEGE values in
> DBA_TAB_PRIVS, and I'm getting closer, but I don't really know what I'm
> doing.

When you connect to Oracle through ODBC you see the objects visible to the user that connected. What user do you connect with and what privileges does that user have?

Try creating a user with no privilege other than CREATE SESSION and see if that limits your view of objects in other schemas. Then GRANT SELECT to that user on a single table in another schema and see if only that table becomes visible.

If not ... I'd like to hear what your experience is.

Daniel A. Morgan Received on Sun Mar 11 2001 - 08:30:42 CST