Re: Grant execute on functions; related objects permissions ?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Tambet Matiisen <t(dot)matiisen(at)aprote(dot)ee>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Grant execute on functions; related objects permissions ?
Date: 2003-01-06 13:50:19
Message-ID: 20030106135019.GA11220@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Jan 06, 2003 at 12:45:25 +0200,
Tambet Matiisen <t(dot)matiisen(at)aprote(dot)ee> wrote:
> btw, views "execute" also with owner's rights, ie if you grant select on view, you do not have to grant select on every table used in view. Still current_user in view returns "caller", while maybe it should return owner?

I don't think so. Knowing the caller is useful for granting access only
to some rows that depend on which user is using the view.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2003-01-06 14:09:28 Re: order by and aggregate
Previous Message Richard Huxton 2003-01-06 13:41:32 Re: order by and aggregate