Last post May 30, 2006 01:46 PM by masterivc
Apr 05, 2006 04:15 PM|Esper|LINK
I am trying to set an administrative user for my personal website starter kit. I dont know how since I am hosting my website on godaddy and not IIS.
May 30, 2006 01:46 PM|masterivc|LINK
SELECT RoleId FROM aspnet_Roles WHERE RoleName = 'Administrators'
Click Submit and save the return value for use in step 11. Click
SELECT UserId FROM aspnet_Users WHERE UserName = '<username>'
Replace <username> with the user name of the account to which administrator privileges will be granted. Retain the single quotation marks around this case-sensitive value. Click
Submit and save the return value for use in step 11. Click
INSERT INTO aspnet_UsersInRoles (RoleId, UserId) VALUES ('<roleID>', '<userID>')
Replace <roleID> with the return value from step 9. Replace <userID> with the return value from step 10. Retain the single quotation marks around these values. Click