Re: Get all the table of another user

Select * from all_tables where owner = '<owner>' and table_name = '<table_name>' will show info, but only if you have privilege on it. replace all by dba and you will see ALL tables (regardless of privilege) but you must have DBA privilege (or the select_catalog_role). Of course this is all well documented, but some people rather post to a newsgroup than reading a concepts manual.

Hth,

Sybrand Bakker, Oracle DBA

Dirk Poppke <poppke_at_iug.cs.uni-dortmund.de> wrote in message news:888snm$r1c$1_at_fbi-news.cs.uni-dortmund.de...
> Hi there!
>
> I would like to display all the owned Table of a different user with
Oracle
> 8.1.5.
> Any Ideas!?
>
> Thanks,
> Dirk
>
>
Received on Mon Feb 14 2000 - 06:39:47 CST