Re: how to create a role with no privileges?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kynn Jones <kynnjo(at)gmail(dot)com>
Cc: Jerry Sievers <gsievers19(at)comcast(dot)net>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: how to create a role with no privileges?
Date: 2014-07-01 17:03:36
Message-ID: 15069.1404234216@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kynn Jones <kynnjo(at)gmail(dot)com> writes:
> In particular, the minimal role still has access to the shell through \!.
> YIKES!!!

What exactly do you find to be "yikes" about that? It's a shell under the
user's own account on the client machine, ie, exactly like the shell
account he invoked psql from. It doesn't really have anything to do with
Postgres at all.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kynn Jones 2014-07-01 17:05:10 Re: how to create a role with no privileges?
Previous Message John R Pierce 2014-07-01 16:58:19 Re: how to create multiple databases running in different dirs