[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: draft Re: [Gnumed-devel] Managing users: restricting access within G
From: |
Karsten Hilbert |
Subject: |
Re: draft Re: [Gnumed-devel] Managing users: restricting access within GNUmed |
Date: |
Fri, 7 Aug 2009 14:11:21 +0200 |
User-agent: |
Mutt/1.5.20 (2009-06-14) |
On Thu, Aug 06, 2009 at 11:29:10PM +0200, Karsten Hilbert wrote:
> No. They would simply get another database account for each
> role. In dem.staff:
>
> - each db_user can only exist once
> - each association of db_user and fk_role must be unique
> thereby by extension each db_user can only have one role
>
> I shall add the restriction that
>
> - each association of fk_role and fk_identity must be unique
>
> Thus, each fk_identity can have several fk_roles but must
> have a different db_user for each :-)
Done.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346