View source

Note: You need access to the database used by Joomla! and this tutorial uses phpMyAdmin

# Using phpMyAdmin or a similar tool, select the Joomla! database.
# Browse to the table "jos_users" (the prefix may be different).
# In phpMyAdmin click the "Browse" tab at the top.
# Find the user whose priviledges you want to take away and edit that user's row.
# If the user is a Super Administrator, the value for "gid" will be "25", change this to "24" and save the row.
# Open the user manager from Joomla! Administrator and edit the user you are changing.
# They are still set as Super Administrator, but you now have the option to change their type through the user manager. Change it to whatever group you wish.

That is it, the user is no longer Super Administrator

If you don't have phpMyAdmin on your server, pass this command through mySQL however you want (assuming the table prefix is jos and the username is user)

<source lang="sql">
UPDATE `jos_users` SET `gid` = '24' WHERE `username` = 'user' LIMIT 1 ;
</source>

[[Category:Tips and tricks]]
[[Category:Tips and tricks 1.0]]