| Lists: | pgsql-admin |
|---|
| From: | "Roger Mathis" <traderx(at)gmx(dot)ch> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Permissions in PgSQL 7.2.1 |
| Date: | 2002-07-03 10:03:49 |
| Message-ID: | 3d22cbf6$0$27221$7402020d@newsfeed.sunrise.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Hi
I have a problem with permissions. I have a user admin1. His permissions are
select, insert, update and delete on table employee.
After connecting with this user, I tried to create a table, and it worked.
Why does this work? I don't want, that admin1 can create tables.
Before I gave admin1 the permissions, I revoked all.
Thanks for your answers.
CU Roger
| From: | Heni Lolov <hal_bg(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Permissions in PgSQL 7.2.1 |
| Date: | 2002-07-05 05:50:28 |
| Message-ID: | 20020705055028.86276.qmail@web21008.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
> I have a problem with permissions. I have a user admin1. His permissions are
> select, insert, update and delete on table employee.
> After connecting with this user, I tried to create a table, and it worked.
> Why does this work? I don't want, that admin1 can create tables.
> Before I gave admin1 the permissions, I revoked all.
> Thanks for your answers.
Everybody is able to create tables in recent releases and there is no way to
stop them :). This is not good at all and this is one of the weaknesses of
PgSQL. But we have the promise drom the developers that it will be fixed in
version 7.3. Probably it will not be done in the best way but it will be better
than nothing.
regards,
Hal
__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com