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
saythe feature I request is security 101.  There are no doubt others that I have not seen nor tested yet.  But not
allowingthat 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@lists.simkin.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
>