Thanks a lot Tom!!!
Thomas Kyte wrote:
> 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 - 20:23:17 CST