GeekArticles
Data Warehousing
Analysis ServicesApplying security to a Dimension
Author: exforsys.com |
Published: 22nd Aug 2005 |
Visited: 200 times |
Add CommentFiled in: OLAPWhen roles are assigned for cubes the user has access or no access to the cube. When roles are assigned to a dimension, the user gains only partial access to parts of the cube. The simplest method of restricting access to a dimension is to prevent access to all levels except the top level of the dimension. In the Cube role dialog box all users were given complete access to the sales cube. Let us restrict the access of users by permitting them to see only values broken out by fiscal years.
Read Article Sponsored Links
Related Articles
• Rethinking Application Security
Discovering security problems early in the development cycle is only the first step toward creating more secure and reliable applications, says Parasoft's Wayne Ariola in an interview with Artima. For developers to work effectively, addressing security-related coding issues must be integrated ...