Last post Oct 20, 2009 02:27 AM by mikeramsey
Oct 20, 2009 01:13 AM|redwoodbev|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.
make new admin
Oct 20, 2009 02:27 AM|mikeramsey|LINK
if you already have the member created that you want as an admin, just run the stored procedure
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