pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedViews and Privileges
2+ messages / 2 participants
[nested] [flat]
* Views and Privileges
@ 2010-06-26 10:11 Matthew Woodcraft <matthew@woodcraft.me.uk>
2010-06-28 19:26 ` Re: Views and Privileges Robert Haas <robertmhaas@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Matthew Woodcraft @ 2010-06-26 10:11 UTC (permalink / raw)
To: pgsql-docs
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-
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Views and Privileges
2010-06-26 10:11 Views and Privileges Matthew Woodcraft <matthew@woodcraft.me.uk>
@ 2010-06-28 19:26 ` Robert Haas <robertmhaas@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Robert Haas @ 2010-06-28 19:26 UTC (permalink / raw)
To: Matthew Woodcraft <matthew@woodcraft.me.uk>; +Cc: pgsql-docs
On Sat, Jun 26, 2010 at 6:11 AM, Matthew Woodcraft
<matthew@woodcraft.me.uk> wrote:
> 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?
I don't see an obvious way to fit it in there, although it doesn't
seem like a bad idea. I also wonder if we should mention something in
the reference pages for GRANT and REVOKE - at least a cross-reference
to the correct section of the documentation.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-06-28 19:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-26 10:11 Views and Privileges Matthew Woodcraft <matthew@woodcraft.me.uk>
2010-06-28 19:26 ` Robert Haas <robertmhaas@gmail.com>
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