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:[EMAIL PROTECTED]]
> Sent: 20 stycznia 2000 11:07
> To:   [EMAIL PROTECTED]
> 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
> 
> 
> ************

************

Reply via email to