<?xml version="1.0"?>
<?xml-stylesheet type="text/css" href="http://docs.joomla.org/skins/common/feed.css?303"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
		<id>http://docs.joomla.org/index.php?title=Removing_super_administrator_rights&amp;feed=atom&amp;action=history</id>
		<title>Removing super administrator rights - Revision history</title>
		<link rel="self" type="application/atom+xml" href="http://docs.joomla.org/index.php?title=Removing_super_administrator_rights&amp;feed=atom&amp;action=history"/>
		<link rel="alternate" type="text/html" href="http://docs.joomla.org/index.php?title=Removing_super_administrator_rights&amp;action=history"/>
		<updated>2013-05-22T20:17:18Z</updated>
		<subtitle>Revision history for this page on the wiki</subtitle>
		<generator>MediaWiki 1.19.3</generator>

	<entry>
		<id>http://docs.joomla.org/index.php?title=Removing_super_administrator_rights&amp;diff=10326&amp;oldid=prev</id>
		<title>Erdsiger: 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 &quot;jos_users...</title>
		<link rel="alternate" type="text/html" href="http://docs.joomla.org/index.php?title=Removing_super_administrator_rights&amp;diff=10326&amp;oldid=prev"/>
				<updated>2008-08-22T11:11:09Z</updated>
		
		<summary type="html">&lt;p&gt;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 &amp;quot;jos_users...&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;Note: You need access to the database used by Joomla! and this tutorial uses phpMyAdmin&lt;br /&gt;
&lt;br /&gt;
# Using phpMyAdmin or a similar tool, select the Joomla! database.&lt;br /&gt;
# Browse to the table &amp;quot;jos_users&amp;quot; (the prefix may be different).&lt;br /&gt;
# In phpMyAdmin click the &amp;quot;Browse&amp;quot; tab at the top.&lt;br /&gt;
# Find the user whose priviledges you want to take away and edit that user's row.&lt;br /&gt;
# If the user is a Super Administrator, the value for &amp;quot;gid&amp;quot; will be &amp;quot;25&amp;quot;, change this to &amp;quot;24&amp;quot; and save the row.&lt;br /&gt;
# Open the user manager from Joomla! Administrator and edit the user you are changing.&lt;br /&gt;
# 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.&lt;br /&gt;
&lt;br /&gt;
That is it, the user is no longer Super Administrator&lt;br /&gt;
&lt;br /&gt;
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)&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
UPDATE `jos_users` SET `gid` = '24' WHERE `username` = 'user' LIMIT 1 ;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
[[Category:Tips and tricks]]&lt;br /&gt;
[[Category:Tips and tricks 1.0]]&lt;/div&gt;</summary>
		<author><name>Erdsiger</name></author>	</entry>

	</feed>