Can we change a user from Super Administrator? [SOLVED]

[ROUBOS]

Hi,
I gave a user Super Administrator privileges and now cannot change it. Is it possible? I am the Super Administrator of the site.
thanks

[webgift]

Right!
I have done that on the past and i removed it from database entry
You can only disable this account.!

It's normal to happen that because it has the "highest" privileges like your account.!

[ROUBOS]

OK thanks.
By the looks of things the a user cannot even change his own privileges from Super Administrator to anything else. Once it's done, it's done!
 
I will delete the entry from the database and re-create the user

[datahell]

This is for security reasons and believe me it is better this way. You can delete a super administrator only from the phpmyadmin.

[ROUBOS]

OK,
I understand the security issues.
If I delete a user from phpMyAdmin, what happens to items they have created on a site? (they are linked to them as authors)

[apkoutsou]

Do not delete the user... Just change the fields 'usertype' and 'gid' to 'Registered' and '18' (if you have not created other user groups than the defaults) respectively and the user is back to a simple register member...

[datahell]

You dont just delete a user. User information are located in several tables in database.
Do what apkoutsou proposed you, it is the simplest solution.
If you want to completely delete the user then make sure you also move his listings to an other user, delete his possible extra fields, update third party components, eblogs, etc, and assign his items/listings to other users. And this should be done via phpmyadmin.

My advice is to never delete a super administrator. Rename him, change his password and change his e-mail address instead.

[webgift]

I supposed that you 've create a user and after that you prefer to delete this.
So i recommend to do what datahell and apkoutsou said above.

[ROUBOS]

Thanks people. Will do that. Appreciate the help.