Re: Row-level security?

On May 28, 10:48 am, Roy Hann <specia..._at_processed.almost.meat> wrote:

> I don't know if relational theory has a lot to say about permissions
> other than to provide the necessary machinery.  What you want is a base
> table to which the user has no access, and a view of that table which is
> restricted to just the rows the user should be able to see.  The user
> is then given permission to select only from the view.

So basically you'd want to do a view for each client? Or, in general, a view for every table for every user where you want row-level access? Received on Thu May 28 2009 - 17:22:49 CEST