Hi Suresh,

All the Other objects are not visible to this user
when connecting via SQLPLUS. The Oracle security is not
seen/enforced by the ODBC. I found a way ( Metalink has a document) where I create views in the users schema which limits the list of the objects listed in the ODBC drop down list box to the following views.

CREATE OR REPLACE VIEW ALL_OBJECTS AS
SELECT * FROM SYS.ALL_OBJECTS
WHERE OWNER IN ('JOEN');


CREATE OR REPLACE VIEW ALL_SYNONYMS AS
SELECT * FROM SYS.ALL_SYNONYMS
WHERE OWNER IN ('JOEN');

However I cannot see other objects to which user has been
given privileges. I would have to create views inside users schema which point to the objects which the user need to query or use.

Did anyone encountered this problem??? Is there a cleaner solution?


Thanks,
CD