| From: | Ian Barwick <ian(at)2ndquadrant(dot)com> |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Clarification for schema and schema object privileges |
| Date: | 2015-07-14 03:24:46 |
| Message-ID: | 55A480FE.1050302@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
Hi
One "gotcha" that crops up from time to time is that it's possible to grant
privileges on objects in a particular schema to a user other than the schema
owner, giving the impression that the user now has those privileges, but if usage on
the schema itself hasn't been granted, the privileges are of course
ineffective. I think it would be worth highlighting this in the documentation
as this seems easy to overlook; suggested patch attached.
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| doc-schema-privilege.patch | text/x-patch | 764 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2015-07-15 04:38:19 | max_worker_processes on the standby |
| Previous Message | Michael Herold | 2015-07-11 15:39:19 | Re: ARRAY[1] || NULL <> array_append(ARRAY[1], NULL) |