[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Jim Busser
Subject: Re: [Gnumed-devel] CCHIT - access restrictions per SOAP note
Date: Wed, 11 Nov 2009 00:06:37 -0800

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)

reply via email to

[Prev in Thread] Current Thread [Next in Thread]