Re: How restrict select on a view ?

On 15/12/2008 17:55, Andreas wrote:

> I'd like to have a view only to be used by certain users.
> The tables are public.

It doesn't seem to make a lot of sense to have public access to the
tables but restrict access to the views.

The usual pattern is the other way around - restrict access to the
tables, and use views to give public (or at least less restricted) to
those subsets of the data you choose.

If you have views with restricted access but leave the tables public,
the users with access to the views can bypass them and go straight to
the tables instead, circumventing your attempts at security.

Then again, maybe I've misunderstood what you're trying to achieve...
can you give more detail?

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------