pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feeddoc change request (7.4.6, reference section, grant)
6+ messages / 4 participants
[nested] [flat]
* doc change request (7.4.6, reference section, grant)
@ 2005-01-31 19:12 Ralph Graulich <maillist@shauny.de>
2005-01-31 20:16 ` Re: doc change request (7.4.6, reference section, grant) Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 6+ messages in thread
From: Ralph Graulich @ 2005-01-31 19:12 UTC (permalink / raw)
To: pgsql-docs
Hi doc keepers,
while I was looking for which privilege is to be granted to a user so the
user can lock tables, I found that information missing in the manual.
Therefore I tried to add it to the sgml doc sources:
postgresql-7.4.6/doc/src/sgml/ref/grant.sgml
134c134,135
< <function>setval</function> functions.
---
> <function>setval</function> functions. Also this privilege is
> required to be able to <literal>LOCK</literal> tables.
Best regards
... Ralph ...
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: doc change request (7.4.6, reference section, grant)
2005-01-31 19:12 doc change request (7.4.6, reference section, grant) Ralph Graulich <maillist@shauny.de>
@ 2005-01-31 20:16 ` Peter Eisentraut <peter_e@gmx.net>
2005-01-31 20:29 ` Re: doc change request (7.4.6, reference section, grant) Ralph Graulich <maillist@shauny.de>
2005-01-31 20:48 ` Re: doc change request (7.4.6, reference section, grant) Alvaro Herrera <alvherre@dcc.uchile.cl>
0 siblings, 2 replies; 6+ messages in thread
From: Peter Eisentraut @ 2005-01-31 20:16 UTC (permalink / raw)
To: maillist@shauny.de; +Cc: pgsql-docs
Ralph Graulich wrote:
> while I was looking for which privilege is to be granted to a user so
> the user can lock tables, I found that information missing in the
> manual.
It's on the reference page of LOCK, where it belongs.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: doc change request (7.4.6, reference section, grant)
2005-01-31 19:12 doc change request (7.4.6, reference section, grant) Ralph Graulich <maillist@shauny.de>
2005-01-31 20:16 ` Re: doc change request (7.4.6, reference section, grant) Peter Eisentraut <peter_e@gmx.net>
@ 2005-01-31 20:29 ` Ralph Graulich <maillist@shauny.de>
2005-01-31 21:31 ` Re: doc change request (7.4.6, reference section, grant) Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 6+ messages in thread
From: Ralph Graulich @ 2005-01-31 20:29 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-docs
Hi Peter,
> It's on the reference page of LOCK, where it belongs.
That's where I finally found it. Comparing the notes on different SQL
commands and the reference page for GRANT, I still consider it's worth
mentioning it there, as it is not that obvious like SELECT, INSERT or
DELETE privileges.
The way the question occured while creating a user allowed to pg_dump
certain databases, but not allowed to do anything else. That way I only
granted SELECT privileges on the tables to that user, but that didn't
work, as pg_dump wants to lock the table.
But anyway, thanks to all the folks writing the documentation, in nearly a
hundred percent of the time the docs are really helpful.
Best regards
... Ralph ...
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: doc change request (7.4.6, reference section, grant)
2005-01-31 19:12 doc change request (7.4.6, reference section, grant) Ralph Graulich <maillist@shauny.de>
2005-01-31 20:16 ` Re: doc change request (7.4.6, reference section, grant) Peter Eisentraut <peter_e@gmx.net>
2005-01-31 20:29 ` Re: doc change request (7.4.6, reference section, grant) Ralph Graulich <maillist@shauny.de>
@ 2005-01-31 21:31 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 6+ messages in thread
From: Tom Lane @ 2005-01-31 21:31 UTC (permalink / raw)
To: maillist@shauny.de; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-docs
Ralph Graulich <maillist@shauny.de> writes:
> The way the question occured while creating a user allowed to pg_dump
> certain databases, but not allowed to do anything else. That way I only
> granted SELECT privileges on the tables to that user, but that didn't
> work, as pg_dump wants to lock the table.
Huh? pg_dump only takes ACCESS SHARE lock, which requires only SELECT
privileges.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: doc change request (7.4.6, reference section, grant)
2005-01-31 19:12 doc change request (7.4.6, reference section, grant) Ralph Graulich <maillist@shauny.de>
2005-01-31 20:16 ` Re: doc change request (7.4.6, reference section, grant) Peter Eisentraut <peter_e@gmx.net>
@ 2005-01-31 20:48 ` Alvaro Herrera <alvherre@dcc.uchile.cl>
2005-01-31 21:19 ` Re: doc change request (7.4.6, reference section, grant) Peter Eisentraut <peter_e@gmx.net>
1 sibling, 1 reply; 6+ messages in thread
From: Alvaro Herrera @ 2005-01-31 20:48 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: maillist@shauny.de; pgsql-docs
On Mon, Jan 31, 2005 at 09:16:11PM +0100, Peter Eisentraut wrote:
> Ralph Graulich wrote:
> > while I was looking for which privilege is to be granted to a user so
> > the user can lock tables, I found that information missing in the
> > manual.
>
> It's on the reference page of LOCK, where it belongs.
It's useful (and consistent) to have a mention on the GRANT page. Else,
the list in GRANT should be a plain list of available privileges,
without the text that currently follows each.
--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"El destino baraja y nosotros jugamos" (A. Schopenhauer)
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: doc change request (7.4.6, reference section, grant)
2005-01-31 19:12 doc change request (7.4.6, reference section, grant) Ralph Graulich <maillist@shauny.de>
2005-01-31 20:16 ` Re: doc change request (7.4.6, reference section, grant) Peter Eisentraut <peter_e@gmx.net>
2005-01-31 20:48 ` Re: doc change request (7.4.6, reference section, grant) Alvaro Herrera <alvherre@dcc.uchile.cl>
@ 2005-01-31 21:19 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 6+ messages in thread
From: Peter Eisentraut @ 2005-01-31 21:19 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@dcc.uchile.cl>; +Cc: maillist@shauny.de; pgsql-docs
Alvaro Herrera wrote:
> It's useful (and consistent) to have a mention on the GRANT page.
> Else, the list in GRANT should be a plain list of available
> privileges, without the text that currently follows each.
In any case, his proposed change was wrong because the required
privileges depend on the lock type. Then you start duplicating all
that information and it's going to become a mess to maintain. The
existing list gives a basic idea of what each privilege is for and
explicitly states that details are to be found on the reference page of
each command. Note that the "basic ideas" are fairly static: the
SELECT privilege is always going to allow SELECT. But I will resist
the demand to duplicate the privilege rules of each command and
function on the GRANT reference page.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2005-01-31 21:31 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-31 19:12 doc change request (7.4.6, reference section, grant) Ralph Graulich <maillist@shauny.de>
2005-01-31 20:16 ` Peter Eisentraut <peter_e@gmx.net>
2005-01-31 20:29 ` Ralph Graulich <maillist@shauny.de>
2005-01-31 21:31 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-01-31 20:48 ` Alvaro Herrera <alvherre@dcc.uchile.cl>
2005-01-31 21:19 ` Peter Eisentraut <peter_e@gmx.net>
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