public inbox for [email protected]
help / color / mirror / Atom feedSECTION 2.8.4 REVOKE CREATE ON SCHEMA
2+ messages / 2 participants
[nested] [flat]
* SECTION 2.8.4 REVOKE CREATE ON SCHEMA
@ 2003-05-07 01:11 Timothy Knowles <[email protected]>
2003-05-07 03:42 ` Re: SECTION 2.8.4 REVOKE CREATE ON SCHEMA Tom Lane <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Timothy Knowles @ 2003-05-07 01:11 UTC (permalink / raw)
To: pgsql-docs
Hi All,
Manual: PostgreSQL 7.3 user manual
Section: 2.8.4
Should the revoke statement read:
REVOKE CREATE SCHEMA ON public FROM PUBLIC;
Instead of
REVOKE CREATE ON public FROM PUBLIC;
Without specifying SCHEMA (on my installation at least) the revoke command
complains about an "invalid privilege type CREATE for table object"
Best Regards,
Tim Knowles
_________________________________________________________________
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/mobile
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: SECTION 2.8.4 REVOKE CREATE ON SCHEMA
2003-05-07 01:11 SECTION 2.8.4 REVOKE CREATE ON SCHEMA Timothy Knowles <[email protected]>
@ 2003-05-07 03:42 ` Tom Lane <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2003-05-07 03:42 UTC (permalink / raw)
To: Timothy Knowles <[email protected]>; +Cc: pgsql-docs
"Timothy Knowles" <[email protected]> writes:
> Manual: PostgreSQL 7.3 user manual
> Section: 2.8.4
> Should the revoke statement read:
> REVOKE CREATE SCHEMA ON public FROM PUBLIC;
> Instead of
> REVOKE CREATE ON public FROM PUBLIC;
You mean
REVOKE CREATE ON SCHEMA public FROM PUBLIC;
But yeah, the example is wrong. Fix committed --- thanks!
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-05-07 03:42 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-07 01:11 SECTION 2.8.4 REVOKE CREATE ON SCHEMA Timothy Knowles <[email protected]>
2003-05-07 03:42 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox