From: Bruno Wolff III <bruno@wolff.to>
To: Tambet Matiisen <t.matiisen@aprote.ee>
Cc: pgsql-sql@postgresql.org
Subject: Re: Grant execute on functions; related objects permissions ?
Date: Mon, 6 Jan 2003 07:50:19 -0600
Message-ID: <20030106135019.GA11220@wolff.to> (raw)
In-Reply-To: <81132473206F3A46A72BD6116E1A06AE1B14BA@black.aprote.com>
References: <81132473206F3A46A72BD6116E1A06AE1B14BA@black.aprote.com>
On Mon, Jan 06, 2003 at 12:45:25 +0200,
Tambet Matiisen <t.matiisen@aprote.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, t.matiisen@aprote.ee
Subject: Re: Grant execute on functions; related objects permissions ?
In-Reply-To: <20030106135019.GA11220@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox