Should I use Membership and Roles in ASP.NET 2.0

Discussion in 'ASP .Net Security' started by msnews.microsoft.com, Oct 31, 2006.

  1. Hello All,

    I did a lot of reading on this new feature from Microsoft ASP.NET 2.0, but I
    ran into a design problem. In my project the user information contains much
    more information then the information shown in the default membership and
    roles tables that are installed with SQL server.

    Therefore I need to link Asp_Tables to my own tables, but then I have an
    issue with transactions, if I delete a user, I need to delete all the User
    information in my tables as well, and that needs to be protected around a
    transaction. I don't want to use System.Transaction because my transactions
    will be promoted to DTC.

    I wonder if there is an elegant solution for this, so I can use ASP.NET
    membership and roles, but yet be able to have additional User information
    and keep everything protected.

    At this point I am starting to think that implementing my own Form
    Authentication is simply the way to go, using my tables with my design.
     
    msnews.microsoft.com, Oct 31, 2006
    #1
    1. Advertising

  2. msnews.microsoft.com

    Jeff Dillon Guest

    Use a stored procedure?? Or a trigger?

    Either support transactions..

    Jeff


    "msnews.microsoft.com" <> wrote in message
    news:ejos6%23Q$...
    > Hello All,
    >
    > I did a lot of reading on this new feature from Microsoft ASP.NET 2.0, but
    > I ran into a design problem. In my project the user information contains
    > much more information then the information shown in the default membership
    > and roles tables that are installed with SQL server.
    >
    > Therefore I need to link Asp_Tables to my own tables, but then I have an
    > issue with transactions, if I delete a user, I need to delete all the User
    > information in my tables as well, and that needs to be protected around a
    > transaction. I don't want to use System.Transaction because my
    > transactions will be promoted to DTC.
    >
    > I wonder if there is an elegant solution for this, so I can use ASP.NET
    > membership and roles, but yet be able to have additional User information
    > and keep everything protected.
    >
    > At this point I am starting to think that implementing my own Form
    > Authentication is simply the way to go, using my tables with my design.
    >
     
    Jeff Dillon, Nov 1, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jeff Jarrell
    Replies:
    3
    Views:
    454
    Jeff Jarrell
    May 25, 2006
  2. pompair
    Replies:
    1
    Views:
    558
    Cowboy \(Gregory A Beamer\)
    Feb 12, 2009
  3. Mark Riley

    Problem using ASP.NET 2.0 Membership and Roles

    Mark Riley, Mar 29, 2006, in forum: ASP .Net Security
    Replies:
    1
    Views:
    131
    Mark Riley
    Mar 30, 2006
  4. C# programmer
    Replies:
    5
    Views:
    176
    C# programmer
    Dec 1, 2006
  5. KT
    Replies:
    1
    Views:
    182
    Dominick Baier
    Dec 11, 2006
Loading...

Share This Page