From: Date: March 31 2009 12:59pm
Subject: bzr commit into mysql-5.1-bugteam branch (staale.smedseng:2840) Bug#39852
List-Archive: http://lists.mysql.com/commits/70882
X-Bug: 39852
Message-Id: <20090331105931.6DEB0D6A2D0@atum21.norway.sun.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============4633715010140449473=="

--===============4633715010140449473==
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

#At file:///export/home/tmp/ss156133/z/b39852-51g/ based on revid:matthias.leich@stripped

 2840 Staale Smedseng	2009-03-31
      Bug #39852 bug in mysql_setpermission
      
      mysql_setpermission is modified to honor the $db 
      variable as suggested when doing a REVOKE ALL for 
      menu option 7.

    modified:
      scripts/mysql_setpermission.sh
=== modified file 'scripts/mysql_setpermission.sh'
--- a/scripts/mysql_setpermission.sh	2007-08-01 09:58:25 +0000
+++ b/scripts/mysql_setpermission.sh	2009-03-31 10:59:22 +0000
@@ -257,7 +257,7 @@ sub addall {
        $sth = $dbh->do("GRANT ALL ON $db.* TO \'$user\'\@\'$host\' IDENTIFIED BY \'$pass\'") || die $dbh->errstr;
     } elsif ($todo == 7) {
        # all privileges set to N
-       $sth = $dbh->do("REVOKE ALL ON *.* FROM \'$user\'\@\'$host\'") || die $dbh->errstr;
+       $sth = $dbh->do("REVOKE ALL ON $db.* FROM \'$user\'\@\'$host\'") || die $dbh->errstr;
     }
     }
   $dbh->do("FLUSH PRIVILEGES") || print STDERR "Can't flush privileges\n";


--===============4633715010140449473==
MIME-Version: 1.0
Content-Type: text/bzr-bundle; charset="us-ascii";
	name="bzr/staale.smedseng@stripped"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

# Bazaar merge directive format 2 (Bazaar 0.90)
# revision_id: staale.smedseng@stripped
# target_branch: file:///export/home/tmp/ss156133/z/b39852-51g/
# testament_sha1: 3396a5e6ee89bd32da272b3942f92f17e42d78af
# timestamp: 2009-03-31 12:59:31 +0200
# base_revision_id: matthias.leich@stripped\
#   o95fgp78cddr4900
# 
# Begin bundle
IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWeKFppoAAavfgEgQXfP//3MP
mQS////0UAQhvdSrLR3d7wO8GiaTUxDT1NJ4m0p5TZDU0NMhoyGjQ00AlFNJiek8imwifqmQwjRk
AGgZAAEoKZCnqNpoT01GQYjQaABo00BkAyomgxNNqDEDQMgBpkyDQ0AASSTJkCZGptARgo9J6jah
o9TQ0AAYFxyU0Hv8hto3zsIwZRHRLEiwBRVElK8KIocNigvz3arVI1w2tMzGKQvlbDK01KU9j0jN
r3Rd+BU0H8f6t/3xCvfCj/E4E+6VDgYYYQw+MuCS3PZzz8mLS+efVWRIyXWsEM5Bmk+KfAFCssuw
rbgIYZSJojdK5BIHpCd11BIe1OJkBeJTIiXjOhRJjhsVSodQr5l7EdqqWWkmlcQgQHNxZkxM9A1J
MJ0mQOgGUdQPH76hVUwHMRE3VFJDzbgkfdSg1EpcSVKbsxig/WRNKD6Bq1kT1oEse1ETovE+uXU5
ihN/h5EgESgw4lcFmWUrGcKLkHWTkrtfC0kHLMwKRUgNLUV5hF+/yafeKdzA82VIxxLHjsMyVWCj
nKXhL5ElfUZRFOLgJsCjXsFrGWFQ0VeOP7QXGYTs0jI2Gk8Z6TYTm5WXFxcnEwpFN8kfGTx2mUgj
iIzYxJh870qx3mKX0oQJGCRjsMFyV5EljIk5Ig4nyRGIJ8yxBDbyMnxOxheLGvTilKWWdr6qnMpZ
7HP0PFiKs+E6YW8qKJSSltRTRc+h9RHUaD7GPwhC2utWoLNclme7CoYUFrvdqFkSeQOBqHgeHceG
2ystDmBC0ofXCQvlikugudpskcjykYMb3iQnryBqLSvSc5qT1gXLA00xHMiD8U3YS3Usu6HeWKZN
WK0/R7xiKutzlO4Wt/s1q4Cc9e+3ike03YxjWbMvApMLGyVDws4mFs9AFnGhS7TYA/tTIjaZcdUT
QLQwYjHQmgKkCKfff1psxlynQ4ExAYXwsj9clQxSKA22Zlg5wYahFVYCVjeY0uSg3CJp1FWVtyiM
EgLCrLMOmIvZcdyxFjZwEyb6NDD+iZL84yTsBg42IXtHtkZctlUFUB7IAZxI9H88TPkxEg2oCJiV
CkQ9hcTJSOopvvoZDC5IYAgeCo/Mk2ZraAqTNVopqL731Zi3sE4orY2s5jAQyHMEj1WPB845mZKb
eShugE7CZbpttcVeXsTGcFJJaK4Itp31A5c3LERt0o2q2k1atSsgd9aKQsz6xdKqhp+q7joFSLIL
COlueBpWNw8LvJEV2zPkZTPlPrdxpTkYFeOLA/rYnYZYUxZPcM152ZAKtc9aN0w4jSwMk6opU6W4
vaWgVJQiX5iRTQOUgx4dYibuOqO/jMX8ORyOBmEdq9omdnS7SOYN5ohQlpBmgpFUrtI4+A8a4hBo
MiGsY9GTNdJgywOjACPTdWlwmmfKORxmc4spugoVGHOoDNDLgAvUQ8m/4u5IpwoSHFC000A=


--===============4633715010140449473==--