Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP NEWBIE: listing of users objects with sql

Re: HELP NEWBIE: listing of users objects with sql

From: <laz777_at_semaphore.com>
Date: Wed, 08 Apr 1998 14:59:29 -0600
Message-ID: <6ggkv1$qpf$1@nnrp1.dejanews.com>


In article <6ggesk$iln$1_at_nnrp1.dejanews.com>,   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

Try the dba_objects table.

-Todd



Todd Marshall
Senior Developer
Semaphore Corp
2001 6th Ave Suite 400		(ph) 206-443-0651
Seattle, WA			(fx) 206-443-0718

98121

I am not a vegetarian because I love animals; I am a vegetarian because I hate plants. -- A. Whitney Brown

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Apr 08 1998 - 15:59:29 CDT

Original text of this message

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