From: | Greg Frith <greg(at)malthouse(dot)demon(dot)co(dot)uk> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | User and Groups |
Date: | 1999-05-05 14:34:36 |
Message-ID: | 99050515531900.00820@ystrad |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi, I'm having some problems trying to get my head around how users and groups
work.
I have 2 groups of users: client & consultants. I create these groups as
follows:-
/* Group : create group consultants */
INSERT INTO pg_group VALUES ('consultants', '100');
INSERT INTO pg_group VALUES ('clients', '200');
I then create some tables and set the permissions on these tables as follows:-
REVOKE ALL ON clients, clientaddr, consultants, consultantaddr,
systemconstants, clients_consultants, tasks, client_extras,
timesheet, schedule, invoice, invoice_items,
pg_user, pg_shadow
FROM GROUP clients;
GRANT ALL ON clients, clientaddr, consultants, consultantaddr,
systemconstants, clients_consultants, tasks, client_extras,
timesheet, schedule, invoice, invoice_items
TO GROUP consultants;
Now I create a user:-
testdb=> CREATE USER paul IN GROUP consultants;
CREATE USER
I login as this user and try a select on a table that should have permissions
set:-
testdb=> select * from consultants;
NOTICE: in_group: group 100 not found
ERROR: consultants: Permission denied.
I can't understand this - should I insert the user id of each consultant user
into grolist of pg_group where groname = consultants?
TOA
--
---------------------------
Greg Frith - University Of Leeds : School of Computer Studies
From | Date | Subject | |
---|---|---|---|
Next Message | Eduardo J. Gargiulo | 1999-05-05 14:44:41 | Authentication |
Previous Message | Carlos Peralta Ramirez | 1999-05-05 08:44:01 | which guru know this ?? |