RE: [GENERAL] Grant problems

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
>
>
> ************

Browse pgsql-general by date

  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