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?
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 - 03:05:36 CST