Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Here it is - view permissions

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: jwieck(at)debis(dot)com
Cc: hackers(at)postgreSQL(dot)org (PostgreSQL-development)
Subject: Re: [HACKERS] Here it is - view permissions
Date: 1998-02-23 13:07:26
Message-ID: 199802231307.IAA20738@candle.pha.pa.us (view raw or flat)
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us

In response to

pgsql-hackers by date

Next:From: Darren KingDate: 1998-02-23 13:08:11
Subject: Re: [HACKERS] Current 6.3 issues
Previous:From: The Hermit HackerDate: 1998-02-23 13:06:33
Subject: Re: [HACKERS] Here it is - view permissions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group