/[H9]/trunk/docs/Database.txt
ViewVC logotype

Diff of /trunk/docs/Database.txt

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 95 by torben, Wed Nov 28 23:23:13 2007 UTC revision 96 by torben, Thu Nov 29 09:51:06 2007 UTC
# Line 92  GRANT select,insert,update,delete ON ins Line 92  GRANT select,insert,update,delete ON ins
92  GRANT select,insert,update,delete ON customer TO serrenab;  GRANT select,insert,update,delete ON customer TO serrenab;
93  GRANT select,insert,update,delete ON logtable TO serrenab;  GRANT select,insert,update,delete ON logtable TO serrenab;
94    
95    -- these sequences are auto created by postgresql
96    GRANT ALL ON customer_id_seq  TO serrenab;
97    GRANT ALL ON command_id_seq TO serrenab;
98    GRANT ALL ON installation_id_seq TO serrenab;
99    GRANT ALL ON logtable_id_seq TO serrenab;
100    GRANT ALL ON users_id_seq TO serrenab;
101    
102  REVOKE create ON SCHEMA public FROM public;  REVOKE create ON SCHEMA public FROM public;
103    
104  INSERT INTO users (realname,username,password,enabled,useradmin) VALUES ('Admin User','admin',md5('admin'),true,true);  INSERT INTO users (realname,username,password,enabled,useradmin) VALUES ('Admin User','admin',md5('admin'),true,true);
Legend:
Removed from v.95  
changed lines
  Added in v.96
  ViewVC Help
Powered by ViewVC 1.1.20