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@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
