Re: find all the tables accessible to a user

In article <20001110183316.11142.00001801_at_ng-cg1.aol.com>,   hongjiew_at_aol.com (Hongjiew) wrote:
> Dear friend, Could you help to do the following:
>
> Given an account and log in, I want to find out all the objects in
 the database
> that are accessible to me (not necessarily owned by me).
>
> thanks.
>
> Hongjie Wang
>
> hongjiew_at_aol.com
>

select owner, object_type, object_name
from all_objects

select * from dict
to see descriptions of all dictionary views available.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.