I have a strange roles problem.

Is there a way we can accomplish this:

Say, the fact table has 100 records. each record having a new account
number (100 accounts in 100 records).

The problem is we have users who have to see only some accounts. For
example, user 1 has to see only accounts 1-10, user 2 has to see only
accounts 11-20, user 3 has to see only accounts 21-30. and so on...

I know we can create different roles and create perspectives for these
roles, but the problem is the list that defines what they can see is a
table of 1000 user entries, each row has its own conditions for each
user type. (Actually, each condition is a combination of different
dimensions. For example, user 1 has to see account 1-10 and products
A-D)

Does anyone have any idea on how to do this?

Thanks in advance