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: How to see user objects from particular user

Re: How to see user objects from particular user

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Mon, 2 May 2005 20:13:54 +0000 (UTC)
Message-ID: <d561m2$9uo$1@klatschtante.init7.net> 





On 2005-05-02, Gregor Maasas <g.maasas_at_gmx.de> wrote:


> How can I select the user_objects from one particular user that is the 

> owner of these objects? I mean something similar to "select * from 

> user_objects" but including one particular user.

>

> Best regards,

> Greg




look into dba_objects and all_objects. These views have a column
named owner.



hth


Rene



-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/


Received on Mon May 02 2005 - 15:13:54 CDT












Original text of this message













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