Re: HELP NEWBIE: listing of users objects with sql
Date: 1998/04/09
Message-ID: <352CCFF9.B912E9E2_at_nospam.nt.com>#1/1
Here's your script. For this one, you would run it as a user who has access to the DBA_OBJECTS view (like the SYSTEM user, etc.). Hope this helps.
Adrian
--***********************************************************
set pages 60
column object_type format a12
column object_name format a30
accept uname char prompt 'Enter the username whose object you want to see: '
select object_type,
object_name,
created,
status
from dba_objects
where owner = upper('&uname');
undefine uname
--**************************************************************
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
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu Apr 09 1998 - 00:00:00 CEST