Re: [Gnumed-devel] CCHIT - access restrictions per SOAP note

[Karsten Hilbert]

On Wed, Nov 11, 2009 at 12:06:37AM -0800, Jim Busser wrote:
> Subject: Re: [Gnumed-devel] CCHIT - access restrictions per SOAP note
> X-Mailer: Apple Mail (2.1076)
> 
> On 2009-11-07, at 11:58 AM, Karsten Hilbert wrote:
> 
> >This is not easily possible. PostgreSQL so far does not
> >natively support row level access permissions.
> 
> Could it manageably be achieved indirectly via Postgres' views in
> which views could include or exclude rows having a specified value?
> 
> If yes, then we could have
> 
> - nonclinical views that all (including staff) could access
> - clinical views (routine) WHERE clin.health_issue.is_confidential
> IS FALSE
> - clinical views (unrestricted)

Wouldn't *all* clinical information be confidential from
non-clinical users regardless of their is_confidential
health issue status ?

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346