function echo_grant_privileges() {
local db=$1
local db_user=$2
local pswd_ro=${db_user}ro
local pswd_rw=${db_user}rw
local pswd_adm=${db_user}adm
echo "GRANT SELECT ON $db.* TO ${db_user}ro identified by \'${pswd_ro}\';"
echo "GRANT SELECT,INSERT,UPDATE,DELETE ON $db.* TO ${db_user}rw identified by \'${pswd_rw}\';"
echo "GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES, CREATE VIEW, SHOW VIEW ON $db.* TO ${db_user}adm identified by \'${pswd_adm}\';"
echo "flush privileges;"
}
$ echo_grant_privileges db toto
GRANT SELECT ON db.* TO totoro identified by \'totoro\';
GRANT SELECT,INSERT,UPDATE,DELETE ON db.* TO totorw identified by \'totorw\';
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES, CREATE VIEW, SHOW VIEW ON db.* TO totoadm identified by \'totoadm\';