Is there any convenient way to discover what content is using specific Viewing Access Levels ? I want to delete the Customer Access Level, in my upgraded to J3.3.0 website, but it gives the error message:

You cannot delete the view access level '4:Customer Access Level' because it is being used by content.

How to find where it is being used, throughout all the database ?

3 Answers 3


If you to view the #__content database table using PhpMyAdmin or something similar, you will see each article on a new row. You will also see across the top the column names. The column name you need to look for is "access". If you scroll down, change every row with the access level of 4 to another value.

If you're unsure which number to change it to, go to view the Access Levels in the Joomla backend and each level has an ID. This is the value you need to change it to.

Hope this helps

  • I was hoping for a mass view tool throughout all the database. But it is ok now. I just found out that content. It was "Special!" module - with the half price on delicious oranges! - meant to be an example for the Customer Access Level. Thanks for the input anyhow.
    – FFrewin
    May 14, 2014 at 9:49

I believe ACL Manager might help with viewing all the access levels:


The screenshots show a grid of components and categories. Not sure if it goes down to the article level.

  • ACL Manager gets my vote
    – BodgeIT
    May 14, 2014 at 15:37
  • I have ACL manager already installed, but unless I am missing something it doesn't handle the case of View Access Levels, rather it is showing the privileges by user/usergroup over items/extensions.
    – FFrewin
    May 14, 2014 at 18:24

It seems that there is no such tool to display all the access levels for all items throughout the website. So, someone will have to go through every component or in the case of following Lodder's answer through the db tables and search/filter for the items that have the Access level in question.

In my case it was the example custom html module that demonstrate the Customer Access Level. Probably this website was initially installed with the demo content.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.