Re: Permissions

Hi Alan

You better believe it.

The best databases on the planet do allow that - Mimer, Sybase and now I am finding Interbase as well. These vendors say the feature I request is security 101. There are no doubt others that I have not seen nor tested yet. But not allowing that feature means there is de facto zero security. As it stands now PG has zero security.

Cheers
Andre

> On 20 Sep 2016, at 23:58, Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca> wrote:
>
> On Tuesday 20 September 2016 23:47:53 Andre Labuschagne wrote:
>> Hi Skylar
>>
>> We are talking about thousands of installations within the organisation.
>> Ideally we need to allow the users at the installations to be able to
>> create their own databases and some of them we supply from head office.
>> The ones we supply applications will be using. When the on site
>> administrators use something like pgAdmin they must not be able to tamper
>> with the databases that we have supplied - no backing up or accessing and
>> so on. Both Sybase and Mimer allow this as explicit login and password is
>> required to each database, even if you are a super user.
>
> PostgreSQL will definitely not help you with that. I find it hard to believe
> any database will allow you to ship a copy to a local admin but will have it
> somehow not be readable by them, but good luck with the commercial products if
> they claim to be able to.
>
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
>