0

I modified a mvc3 application of my company to implement a Role Provider with a role 'admin' which can give permissions to/delete other users.

This has been pretty straight-forward, the problem i'm facing is to add the first 'admin' user by sql syntax, because the Membership Provider uses a hash+salt combination to store user password so inserting a clear password and empty salt won't work.

Is there a way to achieve this by sql, or executing .net code in sql server without loading a CLR assembly?

Thanks!

Sergy93
  • 53
  • 8
  • Replication of http://stackoverflow.com/questions/3124768/sql-to-create-net-membership-provider-users ? – Seany84 Feb 12 '14 at 15:14
  • Thanks, it looks like i didn't search enough :) anyway i already solved it by asigning roles with sql to an already existing user known to me, is a much simpler solution. – Sergy93 Feb 13 '14 at 14:10

0 Answers0