how to create a role with no privileges?

From: Kynn Jones <kynnjo(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: how to create a role with no privileges?
Date: 2014-06-30 20:23:42
Message-ID: CAFvQaj46YRj4PFfyJTigYeehN7Y04=oF2mquTUpCigPE3TbBPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How does one define the most limited role/user possible in PostgreSQL?

Ideally, this role would not be able to do *anything* at all. In
particular, this role would not be able to query meta-information about
existing tables, functions, etc. with backslash commands such as \dt, \df.

(Of course, in practice such a role would not correspond to any real role.
Its purpose, rather, is to serve as the starting point for defining more
realistic roles by selectively adding the fewest privileges possible).

TIA for any pointers!

kynn

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Sievers 2014-06-30 21:37:03 Re: how to create a role with no privileges?
Previous Message David G Johnston 2014-06-30 17:08:46 Re: collecting employees who completed 5 and 10 years in the current month