Re: HELP- How to find all tables created by a user?
From: Mechanical Mann <eric_at_REMOVE_SPAMspeco.com>
Date: Tue, 19 Feb 2002 15:56:43 -0600
Message-ID: <a4uhol$3ff$1_at_bob.news.rcn.net>
Date: Tue, 19 Feb 2002 15:56:43 -0600
Message-ID: <a4uhol$3ff$1_at_bob.news.rcn.net>
Maybe I should have read closer.
SELECT * FROM CAT
"Mechanical Mann" <eric_at_REMOVE_SPAMspeco.com> wrote in message
news:a4ug4v$ras$1_at_bob.news.rcn.net...
Since you have the username/passwd you can log on as that user and execute
> 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 - 22:56:43 CET