From: Matthew Woodcraft <matthew@woodcraft.me.uk>
To: pgsql-docs@postgresql.org
Subject: Views and Privileges
Date: Sat, 26 Jun 2010 11:11:06 +0100
Message-ID: <i04jnr$vu4$1@dough.gmane.org> (raw)
The fact that views run with the privileges of the view owner is a bit
hidden in the documentation.
It isn't mentioned in /3.2 Views/, which makes sense as privileges
haven't been introduced yet.
It is explained in /37.4 Rules and Privileges/, but I think most people
using views won't have reason to read the docs on rules.
I can't find any other reference to it.
How about having a section under /20. Database Roles and Privileges/ on
views and privileges?
-M-
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-docs@postgresql.org
Cc: matthew@woodcraft.me.uk
Subject: Re: Views and Privileges
In-Reply-To: <i04jnr$vu4$1@dough.gmane.org>
* 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