Security Tables in Lifecycle Toolkit: is there an example?

FactProvider at 06h08
27
Mar
2009
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 upd
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
I'm creating a model of our help desk ticket tracking system, and I'm not sure how to model this. We need to do a snapshot of the data because the transactional system will make overwriting updates. It's accumulating because the ticket has a lifecycle
When it rains, it pours...... Sorry to have to post in this forum, too. I received this just minutes ago. It was a "pop up" that came up when I did a search for "Victorian ties". I clicked on a website that was rated ok by WOT,
for more plz chek out the link below. http://ezinearticles.com/?Cisco-CCNA,-CCENT,-and-CCNP-Practice-Questions---Routing-Tables,-BGP,-Port-Security-and-More!&id=1254963
If I have a fact table with a "counter" fact, for example a customer places an order, but then goes back and changes parts of that order any number of times, I want to store how many times the customer changed his/her order. The grain of the
Hi, Is it acceptable to create an aggregate fact table from the staging tables after you have cleaned out the data in staging? I know usually you're supposed to create aggregate fact tables from the fact/dimension tables, however can it be done straigh
Forums from same category
See also
more_less
Informations

2 Replies For the topic :
"Security Tables in Lifecycle Toolkit: is there an example?"

This topic has been viewed 777 times.

Last message :
27/03/2009 at 06h08 by "FactProvider"