Studio – User Row Level Security using a Where Clause

​How to secure access to data at a row level in a Datamodel.
In the example an user account is converted into an Employee ID which is then used to restrict access to a Purchase Order table so that only the matching Employee IDs are show in reports.  In other words the User can only see the Purchase Orders created with their ID.  The video explains how to create a User mapping table and how to use the User OnLogon event to obtain the ID.  This is then placed on the Purchase Order Table Where Clause to restrict the data.

Download Sample

https://skydrive.live.com/?cid=cbe1ede0d0443335#cid=CBE1EDE0D0443335&id=CBE1EDE0D0443335%21773