Changeset 1021 for pykota/trunk/initscripts
- Timestamp:
- 06/10/03 18:37:54 (21 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/postgresql/pykota-postgresql.sql
r1015 r1021 20 20 -- 21 21 -- $Log$ 22 -- Revision 1.2 2003/06/10 16:37:54 jalet 23 -- Deletion of the second user which is not needed anymore. 24 -- Added a debug configuration field in /etc/pykota.conf 25 -- All queries can now be sent to the logger in debug mode, this will 26 -- greatly help improve performance when time for this will come. 27 -- 22 28 -- Revision 1.1 2003/06/05 07:12:31 jalet 23 29 -- Reorganization of directories … … 41 47 -- Create the print quota database users 42 48 -- 43 CREATE USER pykotauser;44 49 CREATE USER pykotaadmin; 45 50 … … 120 125 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON users, groups, printers, userpquota, grouppquota, groupsmembers, jobhistory TO pykotaadmin; 121 126 GRANT SELECT, UPDATE ON users_id_seq, groups_id_seq, printers_id_seq, userpquota_id_seq, grouppquota_id_seq, jobhistory_id_seq TO pykotaadmin; 122 GRANT SELECT, UPDATE ON printers, userpquota, grouppquota TO pykotauser;123 GRANT SELECT ON users, groups, groupsmembers TO pykotauser;124 GRANT SELECT, INSERT, UPDATE ON jobhistory TO pykotauser;125 GRANT SELECT, UPDATE ON jobhistory_id_seq TO pykotauser;126 127