I sometimes wonder if anyone actually reads these blogs :-P
Well, here is my chance to find out.
I am going to ask for feedback.
In my position as a Business Intelligence Consultant, I have been asked before how to implement data based security (DBS). By DBS I mean the ability for an admin user to restrict a row of data from a user based on a value in the database.
For example, I, as an end user of a report, can only see transactions that occurred within my region: Georgia; whereas my peer across the country can only see transactions in Colorado.
I could add a where clause to every report, but what if the admin wants the ability to filter by ANY field in the database.
I have a solution that works quite well, but I am interested to know if anyone else has run into this request, and how they have solved it.
I am going to post my solution later on this week.
I've been asked for this functionality, as well. Am I just overlooking it, or have you not posted your solution yet?
I have posted it now. Let me know if it works for you, and if not, why. I am always looking to improve. :-)
Post a Comment