Re: [HACKERS] Here it is - view permissions - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Here it is - view permissions
Date
Msg-id 199802231307.IAA20738@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Here it is - view permissions  (jwieck@debis.com (Jan Wieck))
List pgsql-hackers
> > This code is big enough without adding system table columns to allow
> > backward compatability.  Just tell them as part of the upgrade, they
> > need to set GRANT/REVOKE on views.  Put it in the /migration files too.
>
>     If  that's  OK  for  all  of  us let's add the information to
>     /migration and the view permissions stuff is done then.

Ok, the following has been added to migration 6.2.1_6.3, and a note has
been added to the item on the TODO/HISTORY list, though you can only see
it now on the www page.


---------------------------------------------------------------------------

In addition, 6.3 has separate permissions for views, rather than relying
on the permissions set on the underlying tables.  For this reason, you will
have to set permissions on your views if you want anything but the
default permissions.




--
Bruce Momjian
maillist@candle.pha.pa.us

pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Here it is - view permissions
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Here it is - view permissions