Re: Question about synonyms

From: bmlam <bmlam_at_online.de>
Date: Sun, 28 Nov 1999 01:13:32 +0100
Message-ID: <384073AC.47A6ADAE@online.de>

I think you want to create a public synonym for a table/view? and then grant privilege on this object to a "group" via a role. Other user who dont have privilege granted on the object will see the synonym in ALL_SYNONYMS, but they cant access the underlying object.

bsoberoi_at_cris.com schrieb:

> Hi there,
>
> Is it possible to create synonyms which is visible only to a group?
>
> Is it possible to create public synonyms and then revoke some grants
> from it?
>
> I will appreciate some response.
>
> Baljit
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Nov 27 1999 - 18:13:32 CST