Most of web developers are now using PHP with MySQL,

Each user role involves a fixed set of privileges on specific database:

Role: Set of privileges:
read select
read/write select, insert, delete, update
dba select, insert, update, drop, create, alter, index