| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | R D <mrk279(at)yahoo(dot)com> |
| Cc: | Kevin Schachter <kevin(at)kevinity(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Granting Permissions to User To Access Database |
| Date: | 2001-01-09 17:50:39 |
| Message-ID: | Pine.LNX.4.30.0101091848230.1538-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
R D writes:
> 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.
> There is one thing I do not like: you can not disallow
> users to create tables. Every user having access to a
> database can create a table in it. This was in the
> todo list of 7.1 but now it is removed. Stupid...
It was not possible to implement it without busting pg_dumpall, thus
creating an upgrading nightmare. It will be in 7.2.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-09 17:53:13 | Re: Connect Failed error |
| Previous Message | vijayendra mohan agrawal | 2001-01-09 11:43:39 | Connect Failed error |