how to use 'aspnet_Membership_CreateUser' directly through T-SQL

Discussion in 'ASP .Net Security' started by Roberto Kohler, Aug 22, 2006.

  1. I would like to be able to use the stored procedure
    'aspnet_Membership_CreateUser' directly through T-SQL code (instead of going
    through .Net wrappers) because I need to automate the creation of hundreds
    of users.

    aspnet_Membership_CreateUser has among others the following parameters:
    @Password, @PasswordSalt, @PasswordAnswer.

    I assume that the @Password and @PasswordAnswer have to be encrypted using
    the @PasswordSalt

    I have been unable to find documentation that explains

    1. how to create the passwordsalt or where to retrieve it from
    2. how to hash/encrypt the password and the security answer.
    Is there another SP that does that?

    Any help would be greatly appreciated.

    Roberto
    Roberto Kohler, Aug 22, 2006
    #1
    1. Advertising

  2. Thats not documented. You can figure it out using Reflector.

    Why not simply write an importer that calls Membership.AddUser instead of
    working at SQL level??

    ---
    Dominick Baier, DevelopMentor
    http://www.leastprivilege.com

    > I would like to be able to use the stored procedure
    > 'aspnet_Membership_CreateUser' directly through T-SQL code (instead of
    > going through .Net wrappers) because I need to automate the creation
    > of hundreds of users.
    >
    > aspnet_Membership_CreateUser has among others the following
    > parameters: @Password, @PasswordSalt, @PasswordAnswer.
    >
    > I assume that the @Password and @PasswordAnswer have to be encrypted
    > using the @PasswordSalt
    >
    > I have been unable to find documentation that explains
    >
    > 1. how to create the passwordsalt or where to retrieve it from
    > 2. how to hash/encrypt the password and the security answer.
    > Is there another SP that does that?
    > Any help would be greatly appreciated.
    >
    > Roberto
    >
    Dominick Baier, Aug 22, 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. Ellie
    Replies:
    1
    Views:
    516
    Andrew Thompson
    Jul 20, 2004
  2. Good Guy
    Replies:
    6
    Views:
    590
    James Kanze
    Oct 20, 2010
  3. Roberto Kohler
    Replies:
    0
    Views:
    435
    Roberto Kohler
    May 30, 2006
  4. LA_Guy
    Replies:
    1
    Views:
    982
    Dominick Baier
    Aug 2, 2006
  5. Sam
    Replies:
    7
    Views:
    65
    Marcel Rodrigues
    Feb 9, 2014
Loading...

Share This Page