Re: SYSTEM VIEWS
Date: Fri, 23 Aug 2002 23:49:37 -0500
Message-ID: <BQs99.13484$Ut4.410728_at_wagner.videotron.net>
A join with user_views and dba_tab_privs will do what you want excluding system view.
MarcM
"Alex" <azp74_at_hotmail.com> wrote in message
news:dca1064b.0208230123.76907035_at_posting.google.com...
> I am using 8i 8.1.5 and I want to import views in to my application.
>
> However, I only want to import user views accessible to a particular
> user, not all of the system views. I can't use the user_views view
> because this only shows me the views a user owns. However, if I use
> all_views, if the user is a power user, I get all the system views.
>
> I've searched the documentation to find out if views are typed or if I
> can filter out the system views with no joy.
>
> OLEDB can tell me that particular views are system views so I figure
> the information must be in there somewhere!
>
> Does anyone out there know?
> TIA
> Alex
Received on Sat Aug 24 2002 - 06:49:37 CEST