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

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP- How to find all tables created by a user?

Re: HELP- How to find all tables created by a user?

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Tue, 12 Mar 2002 23:20:54 GMT
Message-ID: <q3wj8.408$x_2.130729@news1.news.adelphia.net>


I have always disliked logging on as one of my users, I prefer

select table_name
from all_tables
where owner = 'username';

"john q user" <@west.raytheon.com> wrote in message news:3C8E8B6B.3F755754_at_west.raytheon.com...
> connect user/password_at_service
> select * from user_tables;
>
> Mario King wrote:
>
> > Hi,
> >
> > I know the user/password pair of an Oracle user. How do I show all
> > the tables he created - I'm not a DBA and don't have sys password.
> >
> > Thanks.
>
Received on Tue Mar 12 2002 - 17:20:54 CST

Original text of this message

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