Security Tables in Lifecycle Toolkit: is there an example?
Page 1 of 1
Security Tables in Lifecycle Toolkit: is there an example?
In the lifecycle toolkit there is reference to using 'security tables' to limit the rows in the fact table that a user/role can see via views.
For example in the medical industry where you only want the LDAP user (patient) to be able to see rows that are related to the role assigned to them.
The hint is that this will involve a lot less admin than having to alter views every time there is an update.
Apparently there are further articles written about this by Joy. Does anyone know if this is true or does anyone have any examples of how these tables work in practice.
Duncan
For example in the medical industry where you only want the LDAP user (patient) to be able to see rows that are related to the role assigned to them.
The hint is that this will involve a lot less admin than having to alter views every time there is an update.
Apparently there are further articles written about this by Joy. Does anyone know if this is true or does anyone have any examples of how these tables work in practice.
Duncan
FactProvider- Posts : 4
Join date : 2009-03-27
Age : 47
Location : Sydney
P344 if that helps.
P344 if that helps.
FactProvider- Posts : 4
Join date : 2009-03-27
Age : 47
Location : Sydney
Found it
If anyone is interested. The material I was looking for is covered in the Microsoft Data Warehouse Toolkit.
Cheers
Cheers
FactProvider- Posts : 4
Join date : 2009-03-27
Age : 47
Location : Sydney
Similar topics
» Business Requirements Document
» Ebook The Data Warehouse Lifecycle Toolkit, 2nd Edition: Practical Techniques for Building Data Warehouse and Business Intelligence Systems
» Model Design With Several 0 to Many Joins?
» Pictures during the course DW lifecycle in depth, White Plains, NY
» Heterogeneous Security Dimensional Model
» Ebook The Data Warehouse Lifecycle Toolkit, 2nd Edition: Practical Techniques for Building Data Warehouse and Business Intelligence Systems
» Model Design With Several 0 to Many Joins?
» Pictures during the course DW lifecycle in depth, White Plains, NY
» Heterogeneous Security Dimensional Model
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum