RE: Need a script that finds users objects that are also in syste

try:

select object_name from dba_objects where owner = 'SYSTEM' intersect
select object_name from dba_objects where owner = 'USERNAME';

--Scott Shafer
  San Antonio, TX

> -----Original Message-----
> From: Cherie_Machler_at_gelco.com [SMTP:Cherie_Machler_at_gelco.com]
> Sent: Friday, November 17, 2000 3:17 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Need a script that finds users objects that are also in
> system
>
> Does anyone have a script that
> will find all the objects that are owned
> by a user that are also owned by system.
>
> Thanks,
>
> Cherie
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Cherie_Machler_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Nov 17 2000 - 15:44:57 CST