Re: How to see user objects from particular user

Gregor Maasas 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

SELECT ...
FROM all_objects
WHERE owner = <schema_name>;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)