--- trunk/docs/Database.txt	2007/11/27 22:33:19	75
+++ trunk/docs/Database.txt	2007/11/28 10:59:26	76
@@ -70,7 +70,7 @@
    username character(30) NOT NULL, 
    "password" character(32) NOT NULL, 
    enabled boolean NOT NULL DEFAULT true, 
-   useradmin boolean NOT NULL, 
+   useradmin boolean NOT NULL DEFAULT false, 
     PRIMARY KEY (id)
 ) WITHOUT OIDS;
 
@@ -78,3 +78,12 @@
 CREATE UNIQUE INDEX installation_phonenr_idx ON installation (installationphonenr);
 CREATE INDEX logtable_installationnr_idx ON logtable (installationnr);
 CREATE UNIQUE INDEX users_username_idx ON users (username);
+
+CREATE ROLE serrenab LOGIN PASSWORD 'furnacemonitor';
+
+GRANT select,insert,update,delete ON users TO serrenab;
+GRANT select,insert,update,delete ON config TO serrenab;
+GRANT select,insert,update,delete ON command TO serrenab;
+GRANT select,insert,update,delete ON installation TO serrenab;
+GRANT select,insert,update,delete ON customer TO serrenab;
+GRANT select,insert,update,delete ON logtable TO serrenab;
\ No newline at end of file