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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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