Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why select from ALL_* tables?
A copy of this was sent to Jimmy <c6635500_at_comp.polyu.edu.hk>
(if that email address didn't require changing)
On Sat, 26 Jun 1999 10:13:06 -0700, you 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
There are three sets of views.
USER_* -- all objects you own ALL_* -- all objects you have the ability to see DBA_* -- all objects
The ALL_* views only show you objects you are allowed to select, insert, update, delete, execute, etc. they do not show you objects you are not allowed to access. They are *safe*.
You do not want to revoke access to them.
It is the DBA_* views that are more powerful.
--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jun 25 1999 - 21:13:02 CDT