How to create another admin once site is online RSS

• • Reply
  

  redwoodbev

  Member

  29 Points

  166 Posts

  How to create another admin once site is online

  Oct 20, 2009 12:13 AM|LINK

   Hi,  My clubsite is online and working and I have the need to assign admin privledges to another member.  Is there a way to do this?  I tried accessing the site through VS express 2008 and the website menu doesn't have the asp.net configuration option mentioned in the "welcome.htm".  I tried going right into the data base on my server, but the darn thing is in code and I can't tell how to change a user from member to admin.  I'd appreciate any suggetions if someone has done this already.  Thanks.

  club kit make new admin

• • Reply
  

  MikeRamsey

  Member

  240 Points

  37 Posts

  Re: How to create another admin once site is online

  Oct 20, 2009 01:27 AM|LINK

  
  

  if you already have the member created that you want as an admin, just run the stored procedure 

  dbo.aspnet_UsersInRoles_AddUsersToRoles. 

  DECLARE @return_value int
  
  
  EXEC @return_value = [dbo].[aspnet_UsersInRoles_AddUsersToRoles]
  		@ApplicationName = N'YOURAPPLICATIONNAME',
  		@UserNames = N'USERNAME',
  		@RoleNames = N'ROLENAME',
  		@CurrentTimeUtc = N'CURRENTDATE'
  
  
  SELECT 'Return Value' = @return_value

  
  hope that helps

  Best Regards,
  Mike
  MCP - Web Based Client Development .NET 2.0