permissions

From: Roger Koot <roger(at)solidair(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: permissions
Date: 2003-02-21 14:42:28
Message-ID: 3e563ad4$0$20245$19deed1b@news.inter.NL.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I've set up a database 'test1' as user 'test'.
as user 'test' I've added 10 users; user1 to user10
then I created a group 'users' with user1 - user10 in it.
as user 'test' I created a table and
then (as user 'test') I granted the group 'users' full permissions to
this table.
Now I want to connect with OpenOffice over odbc to the postgres database
as user 'user1'. so far so good. in OpenOffice the table shows up just
fine *BUT* although 'user1' has ALL permissions, 'user1' isn't able to
modify, add or delete entries. why not ? what am I missing here ?

in short, I did this:

su - postgres
createuser -d -a -w test
createdb -U test test1
createuser -U test -D -A -w user1
createuser -U test -D -A -w user2
...
createuser -U test -D -A -w user10
psql -U test -d test1
create group users with user user1;
create group users with user user2;
..
create group users with user user10;
create table table1 ( val1 varchar(40, val2 text, val3 char(2));
grant all on table1 to group users;

then i.e. user1 tries to connect thru ODBC to the database, which
succeeds, but user1 fails to modify or add records

TIA
roger

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nigel J. Andrews 2003-02-21 15:28:47 Re: Problem with aliasing
Previous Message Tony Grant 2003-02-21 13:56:54 Re: Backend often crashing