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: john q user <_at_west.raytheon.com>
Date: Tue, 12 Mar 2002 15:12:43 -0800
Message-ID: <3C8E8B6B.3F755754@west.raytheon.com> 





connect user/password_at_service


select * from user_tables;



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 Mar 12 2002 - 17:12:43 CST












Original text of this message













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