Reset Super User Access Rights

Moderators: mandville, General Support Moderators

Anne M
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Tue Mar 23, 2010 4:15 pm

Re: Reset Super User Access Rights

Post by Anne M » Sat Jan 19, 2013 6:19 pm

Thx a million!

User avatar
offhegoes
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Fri Aug 15, 2008 5:27 pm
Location: Bandar Baru Bangi, Selangor, Malaysia
Contact:

Re: Reset Super User Access Rights

Post by offhegoes » Mon May 20, 2013 5:33 am

Thanks.. It does help..

aputney
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Mon Nov 15, 2010 1:06 am

Re: Reset Super User Access Rights

Post by aputney » Fri Aug 23, 2013 7:48 pm

i'm having problems w/permissions too, i got into the database and the "jos_viewlevels" table, but I don't know how to reset the permissions back to the default values...

can anyone enlighten me PLEASE...

thx!

User avatar
abernyte
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4189
Joined: Fri May 15, 2009 2:01 pm
Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड

Re: Reset Super User Access Rights

Post by abernyte » Sat Aug 24, 2013 2:34 am

When you have accessed the database with phpMyadmin at jos_view_levels you should see this:
viewlevels.PNG
Click the edit icon on the left and make the values on right as shown.
***Always backup the database before editing a live site***
You do not have the required permissions to view the files attached to this post.
"Those who expect to reap the blessings of freedom must, like men, undergo the fatigue of supporting it." Thomas Paine

NewJoomby
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Fri Dec 30, 2011 1:57 pm

Re: Reset Super User Access Rights

Post by NewJoomby » Sun Dec 15, 2013 12:36 pm

Thanks! sorted my Blank Admin screen.
My default group had lost the 8 level:- (3 Special 3 [6,3])
Added it back in and up popped my toolbars.

User avatar
mariovns
Joomla! Apprentice
Joomla! Apprentice
Posts: 25
Joined: Fri Apr 01, 2011 3:05 am

Re: Reset Super User Access Rights

Post by mariovns » Thu Jul 03, 2014 1:46 pm

Thank you.

antifmradio
Joomla! Explorer
Joomla! Explorer
Posts: 414
Joined: Sun Feb 07, 2010 3:22 pm
Location: NJ NYC
Contact:

Re: Reset Super User Access Rights

Post by antifmradio » Tue Apr 14, 2015 3:19 pm

This didnt work for me/
my administrator is STILL only ADMIN level and not SUPERUSER

Adnet
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 135
Joined: Wed Nov 24, 2010 8:52 am
Location: Greece
Contact:

Re: Reset Super User Access Rights

Post by Adnet » Thu Apr 28, 2016 10:19 pm

oneski2006 wrote:I managed to resolve this issue.

When I was messing about with permissions I must have changed something.
I went into my database a changed the 'jos_viewlevels' back to there default values and now everything is back where it should be.

1 Public 0 [1]
2 Registered 1 [6,2,8]
3 Special 2 [6,3,8]

In Joomla 3.5 the table has differed name ?
I cant find it.

RobertKza
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Tue Aug 23, 2016 9:34 am

Re: Reset Super User Access Rights

Post by RobertKza » Mon Jan 09, 2017 9:12 am

Hi oneski2006, many thanks for the hint on resetting viewer rights in the SQL database.
Without it there would have been many hours of trauma !!
What I did was look at a copy of my site for another client and copied out the viewing rights.
Not the same figures as yours but worked brilliantly Thanks

bigdogcomm
Joomla! Apprentice
Joomla! Apprentice
Posts: 23
Joined: Mon Aug 23, 2010 8:52 pm
Location: Long Island, New York, USA

Re: Reset Super User Access Rights

Post by bigdogcomm » Tue Mar 27, 2018 9:39 pm

oneski2006 wrote:
I managed to resolve this issue.

When I was messing about with permissions I must have changed something.
I went into my database a changed the 'jos_viewlevels' back to there default values and now everything is back where it should be.

1 Public 0 [1]
2 Registered 1 [6,2,8]
3 Special 2 [6,3,8]
Figured it was a long shot. But... it worked on Joomla3.8.6


Locked

Return to “Access Control List (ACL) in Joomla! 2.5”