View schema for all user objects

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 31 Jul 2003 13:47:24 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703F9CBD9@lnewton.leeds.lfs.co.uk>

Assuming I understand correctly :

look in user_objects - for eveything your user owns. look in all_objects - for everything your users has access to, including stuff in other users to which yours has been given access. Look in dba_objects for everything, assuming you have the rights to do so.

Cheers,
Norm.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: issasal_at_yahoo.com (NoName) [mailto:issasal_at_yahoo.com] Posted At: Tuesday, July 29, 2003 7:22 PM Posted To: server
Conversation: View schema for all user objects Subject: View schema for all user objects

Hey, I'm trying to find all the schema for all user objects. Can somebody direct me in the right place to figure this out? Thanks in advance. Received on Thu Jul 31 2003 - 07:47:24 CDT