document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. function echo_grant_privileges() {
  2.   local db=$1
  3.   local db_user=$2
  4.   local pswd_ro=${db_user}ro
  5.   local pswd_rw=${db_user}rw
  6.   local pswd_adm=${db_user}adm
  7.   echo "GRANT SELECT ON $db.* TO ${db_user}ro identified by \'${pswd_ro}\';"
  8.   echo "GRANT SELECT,INSERT,UPDATE,DELETE ON $db.* TO ${db_user}rw identified by \'${pswd_rw}\';"
  9.   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}\';"
  10.   echo "flush privileges;"
  11. }
  12.  
  13.  
  14. $ echo_grant_privileges db toto
  15. GRANT SELECT ON db.* TO totoro identified by \'totoro\';
  16. GRANT SELECT,INSERT,UPDATE,DELETE ON db.* TO totorw identified by \'totorw\';
  17. 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\';
');