Re: changing user role from database
Hi,
- Get the UserID and UserGuid for the user you want to put in the admin role. To do this, look at the mp_Users table.
- Get the RoleGuid for the Admin role. To do this, look at the mp_Roles table.
- Using the information you gathered in steps 1 and 2, run this statement:
INSERT INTO mp_UserRoles (UserID, RoleID, UserGuid, RoleGuid) VALUES (<UserID from Step 1>, 1, <UserGuid from Step 1>, <RoleGuid from Step 1>);
This should get you set.
Thanks,
Joe