PUBLIC synonyms,views on ORACLE 8.0.4.1.3 via ODBC to ACCESS 97 !

From: Thomas Krobatschek <thomas.krobatschek_at_mhsg.ac.at>
Date: Mon, 06 Jul 1998 11:01:34 +0200
Message-ID: <35A0926E.699A20C0@mhsg.ac.at>

hello to everybody out there on the oracle forum

i have a great problem with my public view´s which are installed from catproc.sql scripts on installing a new database.

every user can see them (yes i know they are public), but I won´t like this
querying in ALL_TABLES, ALL_CATALOGS, V$*, etc.

is there a possibility to reduce the access only to the tables i give to the user.
they should not see any public.* .

is it possible to do this with a small sqlcode of "REVOKE".

please help me because i think
it is one of the most common problem
which probably every admin, who uses odbc, has.

with many thanks in ad.
thomas.krobatschek_at_mhsg.ac.at Received on Mon Jul 06 1998 - 04:01:34 CDT