ODBC ignores priveleges?

From: Gerard Tromp <tromp_at_sanger.med.wayne.edu>
Date: Tue, 22 Jun 1999 14:20:51 -0400
Message-ID: <376FD403.7953465A@sanger.med.wayne.edu>

Greetings,

I have a peculiar situation. When using sqlplus on the server, any particular user can only see the tables created by, or granted to, that user (direcly or via role). When the database is queried using ODBC from a Win95 client, however, all the tables in the tablespace are visible and are selectable. Any clues?

Details:

Database :            7.3.2.0.0
Server_HW:            SparcStation 20
Server_OS:            Solaris 2.5.1

ODBC driver on Win95: 2.5.3.1

Gerard
PS: Please cc me by e-mail; while I will try to read replies on the newsgroup, I have noticed that there are sometimes messages that appear on my newsfeed a week or more after being posted. I would prefer not to miss any responses. Thank you.
--

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Gerard Tromp, Ph.D.
CMMG, Wayne State University    vox:	313-577-8773
3116, Scott Hall		fax: 	313-577-5218
540 E Canfield Ave		e-mail: tromp_at_sanger.med.wayne.edu
Detroit, MI 48201                       gtromp_at_cmb.biosci.wayne.edu

Received on Tue Jun 22 1999 - 13:20:51 CDT