Re: Grants

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 22 Sep 1998 04:10:48 GMT
Message-ID: <360822dc.15105608@netnews.worldnet.att.net>

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

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

If you want to see what tables and views that _you_ have access to, you can just query ALL_TABLES and ALL_VIEWS. There are other views that you as the DBA can query, that will show you who has access to what, but I forget their names at the moment.

Jonathan Received on Mon Sep 21 1998 - 23:10:48 CDT