Changed creation and loading of the clearadm database. Now it works!

[clearscm.git] / clearadm / lib / users.sql

diff --git a/clearadm/lib/users.sql b/clearadm/lib/users.sql
index b89b5b2..b124e3d 100644 (file)
--- 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';