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

heh heh, I missed that too!

at the sql*plus prompt, type: DESC user_tables (to get a listing of what columns there are, in case you need to know more than just the name of the table).

then try: select table_name from user_tables;

(logged in as that user -- as Mechanical Mann correctly pointed out).

At least someone is awake today!!

Mechanical Mann wrote:
>
> Maybe I should have read closer.
> Since you have the username/passwd you can log on as that user and execute
>
> SELECT * FROM CAT
>
> "Mechanical Mann" <eric_at_REMOVE_SPAMspeco.com> wrote in message
> news:a4ug4v$ras$1_at_bob.news.rcn.net...
> > SELECT TABLE_NAME
> > FROM SYS.ALL_TABLES
> > WHERE OWNER LIEK 'user-name';
> >
> >
> > "Mario King" <hliji_at_usa.net> wrote in message
> > news:1ba32e56.0202191321.365877c7_at_posting.google.com...
> > > 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 Feb 19 2002 - 23:04:45 CET