Re: [HACKERS] Here it is - view permissions

From: jwieck(at)debis(dot)com (Jan Wieck)
To: maillist(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian)
Cc: jwieck(at)debis(dot)com, pgsql-hackers(at)postgreSQL(dot)org, pgsql-patches(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Here it is - view permissions
Date: 1998-02-23 08:28:29
Message-ID: m0y6tFV-000BFRC@orion.SAPserv.Hamburg.dsh.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Bruce wrote:
>
> >
> > 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.

If that's OK for all of us let's add the information to
/migration and the view permissions stuff is done then.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SARZ 1998-02-23 08:43:59 RE: [HACKERS] Recursive queries?
Previous Message Jan Wieck 1998-02-23 08:19:58 Re: AW: [HACKERS] triggers, views and rules (not instead)