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?
» Looking for people who will be present at DWH Lifecycle in White Plains NY
» crm issue in The DataWareHouse Toolkit 2nd edition
» 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?
» Looking for people who will be present at DWH Lifecycle in White Plains NY
» crm issue in The DataWareHouse Toolkit 2nd edition
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum