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: pgsql-hackers(at)postgreSQL(dot)org, pgsql-patches(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Here it is - view permissions
Date: 1998-02-21 16:49:55
Message-ID: 199802211649.LAA26669@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> 
>     No,  there  isn't more on that. It's just to be more backward
>     compatible. Users out there  might  have  already  views  and
>     since  it  wasn't neccessary to set explicit permissions on a
>     view up to now (views  inherited  the  permissions  from  all
>     tables  they select), it's unlikely that anyone out there set
>     them up.
> 
>     I think it's better to implement something that's  a  key  to
>     open  the  door  instead of opening it by default and telling
>     where's the key to lock it back.

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.

-- 
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-02-21 18:26:54
Subject: Re: [PATCHES] Here it is - view permissions
Previous:From: Thomas A. SzybistDate: 1998-02-21 15:42:17
Subject: Re: [PORTS] Sparc/Linux oddity...

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