Re: HELP NEWBIE: listing of users objects with sql

On Wed, 08 Apr 1998 13:17:31 -0600, 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.
>
>I would be really thankful if someone could help me.
>
>
>dgc_at_usa.net

Hi,

try this:

SELECT owner, object_name, object_type, status, created   FROM dba_objects
 WHERE owner LIKE upper('&owner')
 ORDER BY owner, status, object_type, object_name

You must run it from an account with dba privileges (e.g. system) in order to see what objects other users own.

HTH,
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Wed Apr 08 1998 - 14:40:50 CDT