Question: I am building an entire system using PHP and MySQL.

I want to create usergroups.

For example
I want *ADMIN1* to be able to **ADD USER**, and **REMOVE USER**

BUT

I want *ADMIN2* to be able to **ADD USER** only

What is the standard way to do this?

Thanks.

Answer: 
You can use system used in drupal ("table\_name"):

"users" [uid, name]

"users\_roles" [uid, rid]

"role" [rid, name]

"permission" [pid, rid, name]
Are you looking for something like this?

```
Create user ‘admin1’ identified by ‘YOUR_PASSWORD’;
Revoke all on * from ‘admin1’;
Grant insert, delete, update, select on YOUR_TABLE to ‘admin1’;

Create user ‘admin2’ identified by ‘YOUR_PASSWORD’;
Revoke all on * from ‘admin2’;
Grant insert on YOUR_TABLE to ‘admin2’;

```