--- trunk/docs/Database.txt 2007/11/29 09:50:32 95 +++ trunk/docs/Database.txt 2007/11/29 09:51:06 96 @@ -92,6 +92,13 @@ GRANT select,insert,update,delete ON customer TO serrenab; GRANT select,insert,update,delete ON logtable TO serrenab; +-- these sequences are auto created by postgresql +GRANT ALL ON customer_id_seq TO serrenab; +GRANT ALL ON command_id_seq TO serrenab; +GRANT ALL ON installation_id_seq TO serrenab; +GRANT ALL ON logtable_id_seq TO serrenab; +GRANT ALL ON users_id_seq TO serrenab; + REVOKE create ON SCHEMA public FROM public; INSERT INTO users (realname,username,password,enabled,useradmin) VALUES ('Admin User','admin',md5('admin'),true,true); \ No newline at end of file