Re: Monitoring roles patch - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Monitoring roles patch
Date
Msg-id 20170328182909.GH9812@tamriel.snowman.net
Whole thread Raw
In response to Re: Monitoring roles patch  (Mark Dilger <hornschnorter@gmail.com>)
List pgsql-hackers
Greetings,

* Mark Dilger (hornschnorter@gmail.com) wrote:
> The inability to revoke access to this sort of information being proposed
> makes me a bit uneasy.

What data are you concerned about, specifically?

> Mostly, I think, I'm bothered because there may
> be people who have revoked privileges on a lot of things, thereby restricting
> access to superuser, who won't necessarily notice this new feature in
> postgres 10.  That could be a source of security holes that we get blamed
> for.

There is no access granted by adding this role without an admin granting
access to this role to some other user.  If they make incorrect
assumptions about what granting access to this role means then I'm
afraid that's their issue, not ours.

> Please note that I'm not specifically opposed to this work, and see a lot
> of merit here.  I'm just thinking about unintended consequences.

Certainly, good to think of, but I don't believe there's a concern here.

Thanks!

Stephen

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Monitoring roles patch
Next
From: Petr Jelinek
Date:
Subject: Re: PoC plpgsql - possibility to force custom or genericplan