Row level authentication RRS feed

  • Question

  • Since lightswitch has built in authentication, is there any way to build relationships to the aspnet_Users table?  Or filter rows entered by specific users?

    If I wanted to associate contact information with a specific user how would I do that?  On a side note, is there any way to insert new users (think register to use the app), or is this a manual chore for the administrator to add new users?

    Monday, March 7, 2011 11:00 PM


  • Hi,

    In Beta 1 there is no easy way to tie your app to the ASP.NET users table; it will be supported in Beta 2.

    You can do row-level authentication by defining permissions on queries and then assigning those permissions to roles and users. You can learn more here: http://msdn.microsoft.com/en-us/library/ff851957.aspx

    As for adding users, it's currently a manual process. For Beta 2 it will be easier to add and authenticate Windows users, but forms auth will still be manual.

    Hope this helps,

    Steve Hoag Microsoft aka the V-Bee
    • Marked as answer by formula13x Tuesday, March 8, 2011 3:39 AM
    Tuesday, March 8, 2011 1:42 AM