[GENERAL] Grant problems

2000-01-20 Thread Balazs Gyetvai 

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

Re: [GENERAL] Grant problems

2000-01-20 Thread J. Roeleveld 

 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

Do the following first:

REVOKE ALL ON "table_name" FROM PUBLIC;

this takes all permissions away from the Public, eg. all users, including
the testuser

hope this helps,

with kind regards,

Joost Roeleveld

RE: [GENERAL] Grant problems

2000-01-20 Thread Andrzej Mazurkiewicz 

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