Re: Granting Permissions to User To Access Database - Mailing list pgsql-admin

From Radoslaw Stachowiak
Subject Re: Granting Permissions to User To Access Database
Date
Msg-id 20010110183335.W24571@blue.alter.pl
Whole thread Raw
In response to Re: Granting Permissions to User To Access Database  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Granting Permissions to User To Access Database  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
*** Peter Eisentraut <peter_e@gmx.net> [Tuesday, 09.January.2001, 18:50 +0100]:
> > This is one of the features of PgSQL that I do not
> > like. It is much nicer to type:
> > "grant all on database.table to ....."
> > And I asked the developers to do that but they did not
> > take it very seriously.
>
> The problem with this approach is that if you do "revoke all on database
> from all" you have hosed your system.  Text files allow recovery in these
> situations.

thats completly wrong :) look at the whole UNIX dir permissions topic.
Using postgres super user, there is NO check on permission (or at least
there should not be).


--
radoslaw.stachowiak.........................................http://alter.pl/

pgsql-admin by date:

Previous
From: "Peter Schmidt"
Date:
Subject: v7.1 & WAL
Next
From: Peter Eisentraut
Date:
Subject: Re: Granting Permissions to User To Access Database