| From: | "Tille, Andreas" <TilleA(at)rki(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | PgAdmin2 trouble (Was: Allow user to create tables) |
| Date: | 2002-05-08 07:30:03 |
| Message-ID: | Pine.LNX.4.44.0205080926410.9220-100000@wr-linux02.rki.ivbb.bund.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 7 May 2002, Tom Lane wrote:
> "Tille, Andreas" <TilleA(at)rki(dot)de> writes:
> > I just created a database and granted all rights to the tables I created to
> > an additional user. I observed that this user does not have the right to
> > create additional tables.
>
> I think you have that backwards ;-). In PG you *cannot prevent* a user
> from being able to create tables.
>
> 7.3 will have permissions that control this, but no extant release does.
Hmm, great :).
Perhaps it is a bug inside PgAdmin2. The user I was talking about is
using this frontend. He gets errors if he tries to create or drop
tables.
But you are right: If I 'su thisuser' and do it in psql I'm able to
do all things he failed to do in PgAdmin2.
Kind regards
Andreas.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tille, Andreas | 2002-05-08 07:34:38 | Re: Allow user to create tables |
| Previous Message | Holger Marzen | 2002-05-08 07:05:50 | Re: Performance issues with compaq server |