row-level access control?

[Peri Tarr]

Hi everyone,

I'm sure I've missed something in the excellent Derby documentation, but I can't find anything about how best to implement row-level access control (i.e., ability to control which users have the right to read or write a particular row). Can someone point me in the right direction?

Thanks so much in advance!

     Peri

[Rick Hillegas-2]

Hi Peri,

You could use triggers to enforce row-level write permissions. You might
be able to use table functions to enforce row level read permissions.

Hope this helps,
-Rick

Peri Tarr wrote:
> Hi everyone,
>
> I'm sure I've missed something in the excellent Derby documentation,
> but I can't find anything about how best to implement row-level access
> control (i.e., ability to control which users have the right to read
> or write a particular row). Can someone point me in the right direction?
>
> Thanks so much in advance!
>      Peri