Security Tables in Lifecycle Toolkit: is there an example?

View previous topic View next topic Go down

Security Tables in Lifecycle Toolkit: is there an example?

Post  FactProvider on Fri Mar 27, 2009 1:08 am

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

FactProvider

Posts : 4
Join date : 2009-03-27
Age : 40
Location : Sydney

View user profile

Back to top Go down

P344 if that helps.

Post  FactProvider on Sun Mar 29, 2009 10:47 pm

P344 if that helps.

FactProvider

Posts : 4
Join date : 2009-03-27
Age : 40
Location : Sydney

View user profile

Back to top Go down

Found it

Post  FactProvider on Wed Apr 01, 2009 10:43 pm

If anyone is interested. The material I was looking for is covered in the Microsoft Data Warehouse Toolkit.

Cheers

FactProvider

Posts : 4
Join date : 2009-03-27
Age : 40
Location : Sydney

View user profile

Back to top Go down

Re: Security Tables in Lifecycle Toolkit: is there an example?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum