Changeset 568 for trunk/jpdd/sql/db.sql

Timestamp:

Sep 17, 2007 3:37:57 AM (6 years ago)

Author:

dkg

Message:

JPDD: more minor cleanup, documenting SQL permission updates required.

File:

• trunk/jpdd/sql/db.sql (modified) (1 diff)

trunk/jpdd/sql/db.sql

@@ -907 +907 @@
 -- record who created a person (if NULL, the account is most likely self-created):
 ALTER TABLE person ADD COLUMN created_by int REFERENCES person(id);
+
+-- fix up permissions:
+
+GRANT SELECT,INSERT,UPDATE ON event TO "www-data";
+GRANT SELECT,UPDATE ON event_id_seq TO "www-data";
+GRANT SELECT,INSERT,UPDATE ON role TO "www-data";
+GRANT SELECT,UPDATE ON role_id_seq TO "www-data";
+GRANT INSERT,UPDATE,DELETE ON person_role TO "www-data";
+GRANT SELECT,UPDATE ON person_role_id_seq TO "www-data";
+GRANT SELECT,INSERT,UPDATE,DELETE ON application TO "www-data";
+GRANT SELECT,UPDATE ON application_id_seq TO "www-data";
+GRANT SELECT ON attendance_requirements TO "www-data";