Changeset 896 for pykota/trunk/initscripts/pykota-postgresql.sql
- Timestamp:
- 04/09/03 22:09:34 (22 years ago)
- Files:
-
- 1 modified
-
pykota/trunk/initscripts/pykota-postgresql.sql (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/pykota-postgresql.sql
r887 r896 20 20 -- 21 21 -- $Log$ 22 -- Revision 1.8 2003/04/09 20:09:34 jalet 23 -- New table to keep job history 24 -- 22 25 -- Revision 1.7 2003/04/08 20:38:08 jalet 23 26 -- The last job Id is saved now for each printer, this will probably … … 105 108 106 109 -- 110 -- Create the job history table for u 111 -- 112 CREATE TABLE jobhistory(id SERIAL PRIMARY KEY NOT NULL, 113 jobid TEXT, 114 userid INT4 REFERENCES users(id), 115 printerid INT4 REFERENCES printers(id), 116 jobsize INT4, 117 jobdate TIMESTAMP DEFAULT now()); 118 119 -- 107 120 -- Create the print quota table for groups 108 121 -- … … 124 137 -- Set some ACLs 125 138 -- 126 REVOKE ALL ON users, groups, printers, userpquota, grouppquota, groupsmembers FROM public;127 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON users, groups, printers, userpquota, grouppquota, groupsmembers TO pykotaadmin;128 GRANT SELECT, UPDATE ON users_id_seq, groups_id_seq, printers_id_seq, userpquota_id_seq, grouppquota_id_seq TO pykotaadmin;139 REVOKE ALL ON users, groups, printers, userpquota, grouppquota, groupsmembers, jobhistory FROM public; 140 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON users, groups, printers, userpquota, grouppquota, groupsmembers, jobhistory TO pykotaadmin; 141 GRANT SELECT, UPDATE ON users_id_seq, groups_id_seq, printers_id_seq, userpquota_id_seq, grouppquota_id_seq, jobhistory_id_seq TO pykotaadmin; 129 142 GRANT SELECT, UPDATE ON printers, userpquota, grouppquota TO pykotauser; 130 GRANT SELECT ON users, groups, groupsmembers TO pykotauser;143 GRANT SELECT ON users, groups, groupsmembers, jobhistory TO pykotauser; 131 144
