Changeset 1087 for pykota/trunk/initscripts
- Timestamp:
- 07/16/03 23:53:08 (21 years ago)
- Location:
- pykota/trunk/initscripts/postgresql
- Files:
-
- 2 modified
-
pykota-postgresql.sql (modified) (3 diffs)
-
upgrade-to-1.14.sql (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/postgresql/pykota-postgresql.sql
r1079 r1087 20 20 -- 21 21 -- $Log$ 22 -- Revision 1.4 2003/07/16 21:53:07 jalet 23 -- Really big modifications wrt new configuration file's location and content. 24 -- 22 25 -- Revision 1.3 2003/07/09 20:17:07 jalet 23 26 -- Email field added to PostgreSQL schema … … 51 54 -- 52 55 CREATE USER pykotaadmin; 56 CREATE USER pykotauser; 53 57 54 58 -- … … 127 131 -- 128 132 REVOKE ALL ON users, groups, printers, userpquota, grouppquota, groupsmembers, jobhistory FROM public; 133 REVOKE ALL ON users_id_seq, groups_id_seq, printers_id_seq, userpquota_id_seq, grouppquota_id_seq, jobhistory_id_seq FROM public; 134 129 135 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON users, groups, printers, userpquota, grouppquota, groupsmembers, jobhistory TO pykotaadmin; 130 136 GRANT SELECT, UPDATE ON users_id_seq, groups_id_seq, printers_id_seq, userpquota_id_seq, grouppquota_id_seq, jobhistory_id_seq TO pykotaadmin; 137 GRANT SELECT ON users, groups, printers, userpquota, grouppquota, groupsmembers, jobhistory TO pykotauser; 131 138 -
pykota/trunk/initscripts/postgresql/upgrade-to-1.14.sql
r1079 r1087 20 20 -- 21 21 -- $Log$ 22 -- Revision 1.2 2003/07/16 21:53:07 jalet 23 -- Really big modifications wrt new configuration file's location and content. 24 -- 22 25 -- Revision 1.1 2003/07/09 20:17:07 jalet 23 26 -- Email field added to PostgreSQL schema … … 40 43 -- 41 44 ALTER TABLE users ADD COLUMN email TEXT; 45 CREATE USER pykotauser; 46 REVOKE ALL ON users, groups, printers, userpquota, grouppquota, groupsmembers, jobhistory FROM pykotauser; 47 REVOKE ALL ON users_id_seq, groups_id_seq, printers_id_seq, userpquota_id_seq, grouppquota_id_seq, jobhistory_id_seq FROM pykotauser; 48 GRANT SELECT ON users, groups, printers, userpquota, grouppquota, groupsmembers, jobhistory TO pykotauser;
