Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP- How to find all tables created by a user?
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