Changeset 1087 for pykota/trunk/initscripts/postgresql/pykota-postgresql.sql

Timestamp:

07/16/03 23:53:08 (21 years ago)

Author:

jalet

Message:

Really big modifications wrt new configuration file's location and content.

Files:

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

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

@@ -20 +20 @@
 --
 -- $Log$
+-- Revision 1.4  2003/07/16 21:53:07  jalet
+-- Really big modifications wrt new configuration file's location and content.
+--
 -- Revision 1.3  2003/07/09 20:17:07  jalet
 -- Email field added to PostgreSQL schema
@@ -51 +54 @@
 -- 
 CREATE USER pykotaadmin;
+CREATE USER pykotauser;
 
 -- 
@@ -127 +131 @@
 --
 REVOKE ALL ON users, groups, printers, userpquota, grouppquota, groupsmembers, jobhistory FROM public;                        
+REVOKE ALL ON users_id_seq, groups_id_seq, printers_id_seq, userpquota_id_seq, grouppquota_id_seq, jobhistory_id_seq FROM public;
+
 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 ON users, groups, printers, userpquota, grouppquota, groupsmembers, jobhistory TO pykotauser;