InstantASP Community Forums
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Client accidently changed... Expand / Collapse
Author
Message
Posted 03/05/2007 07:06:47
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 03/05/2007 20:04:35
Posts: 4, Visits: 8
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
Post #12707
Posted 03/05/2007 14:10:16


Support Supremo

Support SupremoSupport SupremoSupport SupremoSupport SupremoSupport SupremoSupport SupremoSupport SupremoSupport Supremo

Group: Customers
Last Login: 2 days ago @ 19:01:11
Posts: 568, Visits: 2,503
CrashDummy (5/3/2007)
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

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.

Post #12711
Posted 03/05/2007 14:19:44
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 03/05/2007 20:04:35
Posts: 4, Visits: 8
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)

Post #12713
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ryan Healey

Permissions Expand / Collapse

All times are GMT, Time now is 10:13pm

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.078. 8 queries. Compression Disabled.
Home | Products | Purchase | Support | Company | Contact Us
Privacy Statement | © 1999-2007 InstantASP Limited. All Rights Reserved.