We are creating a data warehouse that must restrict access to data for certain classes of users.
||Ask The Experts published in DMReview.com
October 1, 1999
We are creating a data warehouse that must restrict access to data for certain classes of users. To achieve this, we will need row-level security. Have you implemented row level security in a data warehouse? What technique did you use?
David Marco's Answer: When I've had to deal with this situation I've handled it in one of three ways. If, by reading the data I can efficiently decide if the user should be allowed to view it, I do a record selection at the reporting level, meaning within the reporting/query program's code. The second technique is adding a column(s) in the database indicating which user categories can view the data. Third, if your data marts are only accessed by certain user categories, I do not move the restricted data into the data mart.
For more information on related topics visit the following related portals...
Query & Reporting,
David Marco is an internationally recognized expert in the fields of enterprise architecture, data warehousing and business intelligence and is the world's foremost authority on meta data. He is the author of Universal Meta Data Models (Wiley, 2004) and Building and Managing the Meta Data Repository: A Full Life-Cycle Guide (Wiley, 2000). Marco has taught at the University of Chicago and DePaul University, and in 2004 he was selected to the prestigious Crain's Chicago Business "Top 40 Under 40." He is the founder and president of Enterprise Warehousing Solutions, Inc., a GSA schedule and Chicago-headquartered strategic partner and systems integrator dedicated to providing companies and large government agencies with best-in-class business intelligence solutions using data warehousing and meta data repository technologies. He may be reached at (866) EWS-1100 or via e-mail at DMarco@EWSolutions.com.
Provided by IndustryBrains
|Autotask: The IT Business Solution|
Run your tech support, IT projects and more with our web-based business management. Optimizes resources and tracks billable project and service work. Get a demo via the web, then try it free with sample data. Click here for your FREE WHITE PAPER!
|OMG Presents: BPM Think Tank 2006|
BPM Think Tank puts you together with leading BPM experts for highly interactive roundtables. It features case studies, the state-of-the-art from business and technology viewpoints, and directions for future innovation. Arlington, VA, May 23-25, 2006
|Increase Your Existing Data Center Capabilities|
Robert Frances Group believes that the enterprise data center is undergoing significant and sustained transformation?and that Azul Systems has delivered on a new approach to delivering processing and memory resources to enterprise applications...
|Data Validation Tools: FREE Trial|
Protect against fraud, waste and excess marketing costs by cleaning your customer database of inaccurate, incomplete or undeliverable addresses. Add on phone check, name parsing and geo-coding as needed. FREE trial of Data Quality dev tools here.
|Free EII Buyer's Guide|
Understand EII - Trends. Tech. Apps. Calculate ROI. Download Now.
|Click here to advertise in this space|