X-Git-Url: https://defaria.com/gitweb/?a=blobdiff_plain;f=clearadm%2Flib%2Fusers.sql;fp=clearadm%2Flib%2Fusers.sql;h=b124e3da7b150a47cea5b288bcb9921142e47893;hb=d73980ce68238f08ea4925bbd18d502e0284e0a1;hp=b89b5b2459e0add34c91388a14a682690ee174cb;hpb=ceb7db8c45226caebec04a0406521ff3911e59fc;p=clearscm.git

diff --git a/clearadm/lib/users.sql b/clearadm/lib/users.sql
index b89b5b2..b124e3d 100644
--- a/clearadm/lib/users.sql
+++ b/clearadm/lib/users.sql
@@ -11,17 +11,32 @@
 -- Copyright (c) 2010, ClearSCM, Inc., all rights reserved
 --
 -- -----------------------------------------------------------------------------
+
+-- Seems that in order to grant access to a user from really all hosts you need
+-- to do both @'%' and @localhost!
 grant all privileges 
   on clearadm.*
-  to clearadm@"%"
+  to clearadm@'%'
+identified by 'clearscm';
+grant all privileges
+  on clearadm.*
+  to clearadm@localhost
 identified by 'clearscm';
 
 grant select
   on clearadm.*
-  to cleareader@"%"
+  to cleareader@'%'
+identified by 'cleareader';
+grant select
+  on clearadm.*
+  to cleareader@localhost
 identified by 'cleareader';
 
 grant insert, select, update, delete
   on clearadm.*
-  to clearwriter@"%"
+  to clearwriter@'%'
+identified by 'clearwriter';
+grant insert, select, update, delete
+  on clearadm.*
+  to clearwriter@localhost
 identified by 'clearwriter';