Need help setting up users
I want to create a Supervisor role who has the rights to create other users for the site. But if I gave "administer users" rights to Supervisor, I found that he will be able to block me (the admin) out. What's more, this Supervisor will not be able to assign the newly created users to the predefined roles unless I also gave him the "administer permissions" rights. And with that rights, he can practically do anything he wants, which of course, is not what we want.
Any comments?
Thanks

Just found out that you can
Just found out that you can use the RoleDelegation module to give Supervisor the ability to assign role without the "administer permissions" rights.
As for the ability to block the admin user (uid=1), it turns out that people have been talking about it for some time - http://drupal.org/node/46149
I was about to say exactly
I was about to say exactly that. This longstanding issue is finally fixed in D7.
Also since you have direct DB access it pretty simple to un-block yourself or assign yourself any needed roles.
--
Dave Hansen-Lange
Web Developer
Advomatic LLC
East Asia Office
Hong Kong
This module doesn't work for
This module doesn't work for your need about to protect the super admin user (uid = 1)? http://drupal.org/project/protect_critical_users.
Julien Didelet
2 more modules
These 2 modules look interesting too - User Protect and Permissions Lock.