Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Security Tables in Lifecycle Toolkit: is there an example?

Go down

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

Post  FactProvider 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 : 47
Location : Sydney

Back to top Go down

Security Tables in Lifecycle Toolkit: is there an example? Empty P344 if that helps.

Post  FactProvider Sun Mar 29, 2009 10:47 pm

P344 if that helps.

FactProvider

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

Back to top Go down

Security Tables in Lifecycle Toolkit: is there an example? Empty Found it

Post  FactProvider 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 : 47
Location : Sydney

Back to top Go down

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

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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