From: | Andrzej Mazurkiewicz <andrzej(dot)mazurkiewicz(at)polkomtel(dot)com(dot)pl> |
---|---|
To: | "'Balazs Gyetvai'" <balazs(at)securities(dot)hu>, pgsql-general(at)postgreSQL(dot)org |
Subject: | RE: [GENERAL] Grant problems |
Date: | 2000-01-20 11:24:58 |
Message-ID: | 13288F4408ADD11186FF0060B06A431303648BD7@MSGWAW1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
test_table has to be created by different user than testuser. If the table
is created by testuser he is an owner of the table and can do everything
what he wants.
Regards,
Andrzej
> -----Original Message-----
> From: Balazs Gyetvai [SMTP:balazs(at)securities(dot)hu]
> Sent: 20 stycznia 2000 11:07
> To: pgsql-general(at)postgreSQL(dot)org
> Subject: [GENERAL] Grant problems
>
> Hello
>
> I like to create a user who can do the followings on a table: select,
> insert, update
> But he can't delete!
> I tried this: grant INSERT, SELECT, UPDATE on table_name to testuser;
> After this the test user can delete from the table_name table without any
> problems. The testuser is not a superuser.
>
> Plz help, Thanks, Bye
>
>
> ************
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-01-20 11:41:22 | Re: [GENERAL] apache logs to pgsql |
Previous Message | Rachel Greenham | 2000-01-20 11:03:23 | Back-end dying on timestamp value insert |