How to reset permissions and access levels? - Joomla! Forum - community, help and support

some previous topics similar issue:

• my administrator page doesn't show main , sub menus, no way access normal backend, see 'popular articles', 'logged in users', 'messages'

• i did create new levels , groups, not touched super user level , access.

• i did give new permissions new groups, trying hide of admin menus new groups

• i messed acl, how can reset on database phpmyadmin?

it joomla 3.4.1 no other external extensions sobipro

thank you

i suggest taking full backup of database first, via phpmyadmin's export tool. sure both structure , data (default settings work; sure looking @ list of tables when click export). save file safekeeping.

the below not affect group/list has access sections of site, or member of groups -- resets actual viewlevels , groups default. doesn't sound site more broken, in actuality, -- darn sure have database backup!

next need make note of table prefixes using. (hopefully random) sequence of characters @ beginning of every table name.

next, truncate *_usergroups table (meaning drop rows leave table intact).

next, run in sql window -- sure replace "yourprefix" table prefix.

code: select all

insert `yourprefix_usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) values
(1, 0, 1, 18, 'public'),
(2, 1, 8, 15, 'registered'),
(3, 2, 9, 14, 'author'),
(4, 3, 10, 13, 'editor'),
(5, 4, 11, 12, 'publisher'),
(6, 1, 4, 7, 'manager'),
(7, 6, 5, 6, 'administrator'),
(8, 1, 16, 17, 'super users'),
(9, 1, 2, 3, 'guest');


now truncate yourprefix_viewlevels. replace yourprefix below prefix, , paste sql tool again:

code: select all


insert `yourprefix_viewlevels` (`id`, `title`, `ordering`, `rules`) values
(1, 'public', 0, '[1]'),
(2, 'registered', 1, '[6,2,8]'),
(3, 'special', 2, '[6,3,8]'),
(5, 'guest', 0, '[9]'),
(6, 'super users', 0, '[8]');


be careful , you'll fine.