Changeset 1021 for pykota/trunk/initscripts/postgresql

Timestamp:

06/10/03 18:37:54 (21 years ago)

Author:

jalet

Message:

Deletion of the second user which is not needed anymore.
Added a debug configuration field in /etc/pykota.conf
All queries can now be sent to the logger in debug mode, this will
greatly help improve performance when time for this will come.

Files:

• pykota/trunk/initscripts/postgresql/pykota-postgresql.sql (modified) (3 diffs)

pykota/trunk/initscripts/postgresql/pykota-postgresql.sql

@@ -20 +20 @@
 --
 -- $Log$
+-- Revision 1.2  2003/06/10 16:37:54  jalet
+-- Deletion of the second user which is not needed anymore.
+-- Added a debug configuration field in /etc/pykota.conf
+-- All queries can now be sent to the logger in debug mode, this will
+-- greatly help improve performance when time for this will come.
+--
 -- Revision 1.1  2003/06/05 07:12:31  jalet
 -- Reorganization of directories
@@ -41 +47 @@
 -- Create the print quota database users
 -- 
-CREATE USER pykotauser;
 CREATE USER pykotaadmin;
 
@@ -120 +125 @@
 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON users, groups, printers, userpquota, grouppquota, groupsmembers, jobhistory TO pykotaadmin;
 GRANT SELECT, UPDATE ON users_id_seq, groups_id_seq, printers_id_seq, userpquota_id_seq, grouppquota_id_seq, jobhistory_id_seq TO pykotaadmin;
-GRANT SELECT, UPDATE ON printers, userpquota, grouppquota TO pykotauser;
-GRANT SELECT ON users, groups, groupsmembers TO pykotauser;
-GRANT SELECT, INSERT, UPDATE ON jobhistory TO pykotauser;
-GRANT SELECT, UPDATE ON jobhistory_id_seq TO pykotauser;