Re: HELP- How to find all tables created by a user?
From: Bricklen <bricklenREMOVETHIS_at_shaw.ca>
Date: Tue, 19 Feb 2002 21:28:24 GMT
Message-ID: <3C72C2FC.20CACC3F_at_shaw.ca>
Date: Tue, 19 Feb 2002 21:28:24 GMT
Message-ID: <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 19 2002 - 22:28:24 CET