Removing super administrator rights: Difference between revisions
From Joomla! Documentation
New page: 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... |
Corrected Super Administrator to Super User. Other markup changes. |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
Note: You need access to the database used by Joomla! and this tutorial uses phpMyAdmin | Note: You need access to the database used by Joomla! and this tutorial uses phpMyAdmin | ||
# Using phpMyAdmin or a similar tool, | # Using phpMyAdmin or a similar tool, open the Joomla! database. | ||
# Browse to the table | # Browse to the table ''jos_users''. (The prefix will be different.) | ||
# In phpMyAdmin click the | # In phpMyAdmin click the ''Browse'' tab at the top. | ||
# Find the | # Find the User whose privileges you want to take away and edit that User's row. | ||
# If the | # If the User is a Super User, the value for ''gid'' will be ''25'', change this to ''24'' and save the row. | ||
# Open the | # Open the User Manager in the Joomla! Administrator and edit the User you are changing. | ||
# They are still set as Super | # They are still set as Super User, but you now have the option to change their type through the User Manager. Change it to whatever group you wish. | ||
That is it | That is it. The user is no longer a Super User. | ||
If you don't have phpMyAdmin on your server, pass this command through | 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''.) | ||
< | <syntaxhighlight lang="sql"> | ||
UPDATE `jos_users` SET `gid` = '24' WHERE `username` = 'user' LIMIT 1 ; | UPDATE `jos_users` SET `gid` = '24' WHERE `username` = 'user' LIMIT 1 ; | ||
</ | </syntaxhighlight> | ||
[[Category:Tips and tricks]] | [[Category:Tips and tricks]] | ||
Latest revision as of 00:08, 11 December 2022
Note: You need access to the database used by Joomla! and this tutorial uses phpMyAdmin
- Using phpMyAdmin or a similar tool, open the Joomla! database.
- Browse to the table jos_users. (The prefix will be different.)
- In phpMyAdmin click the Browse tab at the top.
- Find the User whose privileges you want to take away and edit that User's row.
- If the User is a Super User, the value for gid will be 25, change this to 24 and save the row.
- Open the User Manager in the Joomla! Administrator and edit the User you are changing.
- They are still set as Super User, 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 a Super User.
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.)
UPDATE `jos_users` SET `gid` = '24' WHERE `username` = 'user' LIMIT 1 ;