Re: HELP NEWBIE: listing of users objects with sql

From: Jamie Keir <jkerr_at_jameswatt.ac.uk>
Date: 1998/04/09
Message-ID: <352C8756.784118B5_at_jameswatt.ac.uk>#1/1


dgc_at_usa.net wrote:
>
> Trying to do the following:
> Create a script that reports on all objects owned by a specific user.
> The username is a parameter. The report includes object_type, object_name
> , when it was created and status.

select object_name,object_type,created,status from all_objects
where owner = &victim;

or am I missing the point?

Jamie Keir Received on Thu Apr 09 1998 - 00:00:00 CEST

Original text of this message