Re: how to create a role with no privileges?

From: Kynn Jones <kynnjo(at)gmail(dot)com>
To: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: how to create a role with no privileges?
Date: 2014-07-01 19:30:11
Message-ID: CAFvQaj4B1roA3XMwgYeHtpYn2L7NcQKdTRcqL4zgMcQYA-mPzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 1, 2014 at 1:28 PM, David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com
> wrote:

> The first rule regarding PostgreSQL permissions is that everything is
> forbidden unless allowed - via GRANT. REVOKE simply undoes whatever has
> been granted; it does not put up a block to prevent inheritance of granted
> permissions.
>

Thanks!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2014-07-01 19:32:25 Re: lock contention, need profiling idea
Previous Message Jeff Janes 2014-07-01 19:28:03 Re: lock contention, need profiling idea