Re: Why select from ALL_* tables?

The ALL_ tables list the objects on which the user has privileges -- not necessarily all objects in the database.

If the user queries on USER_TABLES, he gets a list of his own tables. If he queries on ALL_TABLES, he gets a list of tables on which he has access -- his own tables plus tables on which privileges (SELECT, INSERT, DELETE etc) have been granted to him. Only if he as the DBA Role DBA_TABLES. Jimmy wrote:
>
> Hello all,
> 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?
>
> Thanks,
> JImmy
Received on Sun Jun 27 1999 - 02:33:24 CDT