Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Grants

Re: Grants

From: Jurij Modic <jmodic_at_src.si>
Date: Mon, 21 Sep 1998 18:33:39 GMT
Message-ID: <36069b7c.3331734@news.siol.net>


On Mon, 21 Sep 1998 17:34:39 +0200, "Josef Huber" <josef.huber_at_ennstal.at> wrote:

>Hello,
>
>Is there a view where i can see to what tables,views,sequences the user has
>access ?

ALL_TABLES, ALL_VIEWS, ALL_SEQUENCES.... If you want to list those objects to which user has access but are owned by somebody else, include the following condition in the query: "... WHERE owner != user".

>Ciao,
>Joe

Regards,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Mon Sep 21 1998 - 13:33:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US