| From: | Mike Christensen <mike(at)kitchenpc(dot)com> |
|---|---|
| To: | Christophe Pettus <xof(at)thebuild(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Question about schema-level permissions |
| Date: | 2012-05-11 04:52:13 |
| Message-ID: | CABs1bs2jZKoiGwuH2CJ+0NZdDugBKwnffVUWkitqgdaEZTWRuQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Excellent, thanks so much!
Mike
On Thu, May 10, 2012 at 9:38 PM, Christophe Pettus <xof(at)thebuild(dot)com> wrote:
>
> On May 10, 2012, at 9:16 PM, Mike Christensen wrote:
>> Am I missing something? Doesn't GRANT ALL mean that user can do
>> anything they want with objects in that schema, including inserts?
>
> No, it means that user has all privileges on *schema itself*; the objects inside of it have their own permissions. What you are looking for is:
>
> GRANT ALL ON ALL TABLES IN SCHEMA Indexer TO Indexer;
>
> --
> -- Christophe Pettus
> xof(at)thebuild(dot)com
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2012-05-11 08:53:25 | Re: Sequence scan if "OR Condition" in where statement |
| Previous Message | Christophe Pettus | 2012-05-11 04:38:24 | Re: Question about schema-level permissions |