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

[Sebastian Hilbert]

Am Samstag 07 November 2009 20:58:49 schrieb Karsten Hilbert:
> On Sat, Nov 07, 2009 at 10:59:45AM -0800, Jim Busser wrote:
> > >requirement:
> > >
> > >Enter some information to be identified as “confidential,” for
> > >example, that
> > >the patient had once been a victim of domestic violence, into the
> > >chart and
> > >designate as accessible only to Physician Users.
> > >...
> > >
> > >This is handled at database level already ,isn't it ?
> >
> > This exists in the table clin.health_issue as boolean field
> > is_confidential
> >
> > Karsten, if the affected row were to be refused access permissions
> 
> This is not easily possible. PostgreSQL so far does not
> natively support row level access permissions.
> 
> Karsten
> 
All I could find is that 
http://bytes.com/topic/postgresql/answers/422181-row-level-security-possible