Advertisement
Guest User

Untitled

a guest
Sep 12th, 2012
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.86 KB | None | 0 0
  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';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement