Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why select from ALL_* tables?

Re: Why select from ALL_* tables?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 26 Jun 1999 02:13:02 GMT
Message-ID: <377636c9.1818835@newshost.us.oracle.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US