Re: HELP- How to find all tables created by a user?
From: Stein Andersen <stein.andersen_at_no.ibm.com>
Date: Tue, 26 Feb 2002 10:05:36 +0100
Message-ID: <a5fj4n$g1s$1_at_news.btv.ibm.com>
Date: Tue, 26 Feb 2002 10:05:36 +0100
Message-ID: <a5fj4n$g1s$1_at_news.btv.ibm.com>
connects as the user and use "select * from user_tables;"
"Bricklen" <bricklenREMOVETHIS_at_shaw.ca> wrote in message
news:3C72C2FC.20CACC3F_at_shaw.ca...
> select * from all_tables where owner = 'your_user';
>
> 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 Feb 26 2002 - 10:05:36 CET