Re: Diff between user/all/dba

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 19 Jan 2003 08:56:24 -0800
Message-ID: <b0elbo02h59@drn.newsguy.com>

In article <7rAW9.1209$hW4.828_at_newssvr19.news.prodigy.com>, Praveen says...
>
>Hi..All,
>
> As far as my understanding goes dba_* are all the tables that can
>be accessed by the dba's. So, what is the difference between user_* &
>all_* data dictionary tables.
>
>N/
>

dba = everything, including things you "cannot access" (eg: you might see a table T in DBA_OBJECTS that you cannot select from)

all = everything you have the privelege to see. you will not see a table T in ALL_OBJECTS unless you can "see" that table in a query)

user = your stuff, things you own.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Sun Jan 19 2003 - 10:56:24 CST