changing user role from database

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>);