From: | Denis Chavez <dnchavez(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Group exclusion question |
Date: | 2002-03-20 21:56:54 |
Message-ID: | 9371.1016661414@www47.gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello!
I wonder if it is possible to create mutually exclusive groups in postgres.
I want to implement a rbac scheme and users must belong to only one group. I
tried:
CREATE TRIGGER group_exclusion BEFORE UPDATE OR INSERT ON pg_group
FOR EACH ROW EXECUTE PROCEDRE check_group_exclusion();
AND
CREATE RULE group_exclusion AS ON UPDATE TO pg_group WHERE not NEW.grolist =
OLD.grolist ....
but it seems that the CREATE USER command doesn't fire the UPDATE of
pg_group with neither triggers nor rules and so nothing happens. Any ideas or
comments?
Regards and thanks in advance.
Denis
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Langille | 2002-03-20 22:13:09 | Re: BBS on postgreSQL? |
Previous Message | Elaine Lindelef | 2002-03-20 21:55:08 | BBS on postgreSQL? |