Advice/your thoughts needed on the subject of user(group)s

Classic Servoy
1

Dear Forum,

I need some advice since I don’t know how to take the right approach here.

I am working on an application where my customer wants to grant users the right to do/see some forms, fields etc.

Now Servoy has a wonderfull security feature so I can use that but:

Talking to my customer it seems hard to give a user ‘a certain fixed profile’.
Following his thought process I would almost define a usergroup per user…

To take away the discussion I could say: sorry, I will define x groups and that’s it!

I also could say I have, let’s say, three goups where group 2 can have it’s profile defined in the application. the customer would then check or uncheck the user for a certain form/field…

The first option is not the right approach from a customerservice perspective. But, I am afraid that the second option would cost too much time to build the form since every element has to be checked before every show on not only on one but maybe ten or twenty variables…

What would you do, can you give me some suggestions?

Thanks in advance.

2

I would create my own user database. Actually I am doing that now.
It’s more work but it gives you so much more control.

For FMPro I had created a 5 ‘table’ solution in a single file (for security reasons and to preserve files because of the 50 file limit) for adding users, adding groups, assigning users to a group and give a group privileges.
It also has a preference table so each user can store it’s own prefs.

I just had to use a template file I made to use it with this user db and add it to the modules table and viola.
I could start building a new module.

Here is the ERD of this FMPro solution.
You could expand this model by making the group table hierarchical so priveliges can be inherited. :)

HTH

3

Thanks Robert, I will give this some thourough thoughts…