Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP- How to find all tables created by a user?

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@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 - 15:28:24 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US