Re: Why select from ALL

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sun, 27 Jun 1999 16:00:30 GMT
Message-ID: <377c499b.8898986@netnews.worldnet.att.net>

On Sat, 26 Jun 1999 10:13:06 -0700, Jimmy <c6635500_at_comp.polyu.edu.hk> wrote:

>Why a user can select from ALL_* table (e.g. ALL_OBJECTS) in Oracle
>7.3.3? What's is the role the user has so that the user can do this kind
>of selection? Is it possible to make the user cannot do selection on
>these kind of tables?

I've never tried restricting a user's access to all_tables. You might be able to do it by logging on as the user SYS and issueing this command:

revoke select on all_tables to public;

There's really no reason to do this however. ALL_TABLES does not really let a user see ALL the tables in your database. It only lets the user see a list of all the tables to which you have granted him access. Presumably, if you've granted a user access to something, you do want him to see it.

regards,

Jonathan

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Sun Jun 27 1999 - 11:00:30 CDT

Re: Why select from ALL_* tables?