Re: Increasing security level by restricting Dataset access to associated user on SQL server

["Chris Travers" <..hidden..>]

Hi Nils;

My suggestion is that you take a look at /trunk/sql/modules/Roles.sql
for a good place to start.  The db has been changed in some ways in
trunk, but from there you can create groups that you can grant
individual users to.

1.3 will do what you are trying to do by default, so we have put a lot
of effort into an infrastructure for that.  However, it is still
pre-beta and backporting this sort of thing will be somewhat
difficult.

You may also want to look at the changes from LedgerSMB/Session/DB.pm
in 1.2 to LedgerSMB/Auth/DB.pm in trunk.

Best Wishes,
Chris Travers