Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP NEWBIE: listing of users objects with sql
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
2001 6th Ave Suite 400 (ph) 206-443-0651 Seattle, WA (fx) 206-443-0718
-----== 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
![]() |
![]() |