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@securities.hu]
> Sent: 20 stycznia 2000 11:07
> To: pgsql-general@postgreSQL.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
>
>
> ************