Re: Pros and cons of giving someone superuser privilege - Mailing list pgsql-admin

From Stephen Frost
Subject Re: Pros and cons of giving someone superuser privilege
Date
Msg-id 20140425145224.GN2556@tamriel.snowman.net
Whole thread Raw
In response to Re: Pros and cons of giving someone superuser privilege  (Daniel Gomez Blanco <nanodgb@gmail.com>)
Responses Re: Pros and cons of giving someone superuser privilege  (Daniel Gomez Blanco <nanodgb@gmail.com>)
List pgsql-admin
* Daniel Gomez Blanco (nanodgb@gmail.com) wrote:
> >From your reply and considering why I have just said, I think that, in our
> case, these users would be better off without superuser access. As for
> their day-to-day operations they wouldn't need it as long as they can
> create their databases and roles, and execute the rest of operations on the
> web interface.

Just to hit on this again- that means your users can't install any
extensions (not even those provided as part of PG through contrib).
Eventually, users will get upset by the lack of things like PostGIS.

They also can't create stored procedures using any of the untrusted
languages (of course, if they could, they could get access to the host,
so that may be a show-stopper anyway).

    Thanks,

        Stephen

Attachment

pgsql-admin by date:

Previous
From: Daniel Gomez Blanco
Date:
Subject: Re: Pros and cons of giving someone superuser privilege
Next
From: Daniel Gomez Blanco
Date:
Subject: Re: Pros and cons of giving someone superuser privilege