InstantASP Community Forums / InstantForum.NET 4.x / Community Support / Client accidently changed permissions on admin account / Latest Posts

RE: Client accidently changed permissions on admin account

CrashDummy — Thu, 03 May 2007 14:19:44 GMT

Thanks Carlos, that got me part way there.

The rest of the way was to insert a record back into the InstantASP_UserRoles table to re-associate User 1 to Role 5 so the Admin CP link would show up in the top menu again.

INSERT INTO InstantASP_UsersRoles UserID, RoleID VALUES (1, 5)

RE: Client accidently changed permissions on admin account

Carlos Muniz — Thu, 03 May 2007 14:10:16 GMT

[quote][b]CrashDummy (5/3/2007)[/b][hr]The admin account now has been changed from the default permission set to "moderator" leaving no admin-enabled accounts. Is there any way to create a new admin account or re-enable admin permisions for the admin account?

Pardon me if this has been asked & answered before, but I couldn't find anything on point using the search tool.

-- Mark[/quote]

Dear Mark,

if this one is the unique admin account, you will have to do it via SQL SERVER running the sql command bellow:

update InstantASP_Users set

primaryroleid= 5 where userid = 1

It should fix your problem.

Client accidently changed permissions on admin account

CrashDummy — Thu, 03 May 2007 07:06:47 GMT

The admin account now has been changed from the default permission set to "moderator" leaving no admin-enabled accounts. Is there any way to create a new admin account or re-enable admin permisions for the admin account?

Pardon me if this has been asked & answered before, but I couldn't find anything on point using the search tool.

-- Mark