Help required to implement security...

Mariusz I followed your video and it worked like a magic! Thanks a lot..

But I dont want to stop there. I would like to understand step by step. So that if I come across any such requirement I can manage it myself.

I have couple of more questions,

1. Your solution works perfectly if all the groups exists in the security table. Like in your example, we have group called as "a" and "b" only. What if there is a group called "c" in the FACT table but that has not been given access to any of the users? So in your sample access to "c" will not given to so and so users. So can you please provide me one more sample if possible which can handle these sorts of scenario?

2. As I mentioned in the initial post getting the output with the desired data set will resolve this issue but what if the volume of the records is huge. This will definitely add number of records drastically. So is there is any better solution for this which is much optimized?

Sorry to add some more questions to the post. Didn't wanted to create new post for the same since it will loose the continuity. Hope you can understand...