Re: HELP NEWBIE: listing of users objects with sql

From: <cmohan_at_iname.com>
Date: Thu, 09 Apr 1998 16:51:33 -0600
Message-ID: <6gjft5$68t$1@nnrp1.dejanews.com>

SELECT object_type, object_name, date, status from dba_objects where owner = &username;
When you run this SQL, you will be prompted to enter the username. Enter username within quotes, typically username in Capitals.

Enjoy,
CM

In article <6ggkv1$qpf$1_at_nnrp1.dejanews.com>,   laz777_at_semaphore.com wrote:
>
> 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
>

-----== 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 - 17:51:33 CDT