User access to subsets of data

[douggiefox]

Hi

The system I am currently developing has a core requirement that different users will have access to different subsets of data. For instance, in the UK a user may only access UK data but a manager from Italy may have access to both UK and Italian data. I could naturally determine this through SQL but it seems clumsy plus on every SQL statement I would need to remember to filter by country dependent on user. Does anyone have any ideas how to acheive this in a more fluid way?

Best

DF

[too_many_details]

which database are you using?

[douggiefox]

mySQL version 5.

DF

[too_many_details]

shame, because if it was Oracle, i could have told you about their solution to this problem.

For what its worth, i do think the logic to filter the rows should go in the db.

Rakesh

[Costin Leau]

It depends on what access tool are you using - Hibernate for example has filters which take care of exactly your problem. they basically restrict the queries based on your conditions.
You'll probably have to do the same thing.

P.S. Not sure how good mysql 5 is, but you might want to take a look at the 'views' support.

[Huehnerbrust]

Hi!

I know this an old thread, but I have the same problem.

I want different users to access different data. In my case it is not country dependend. User create their own data and as long as auser does not grant access to his data only he can work with the data.

Could you please tell me how that feature is called in hibernate?
What is the way to handle this cases in spring3? Should I still use hibernate for user-data management?

Maybe not the right thread, but how would I load data with a persistence api at login time, not at startup time of the server?

Thanks
Dominik