From 4a039197705f92ee1c362401a7f7bb834ecc9079 Mon Sep 17 00:00:00 2001 From: Jeremy Kerr Date: Thu, 9 Oct 2008 22:49:18 +1100 Subject: [sql] use separate grant-all scripts for postgresql and mysql Mysql doesn't support granting to multiple tables, and requires a different username format. Would be nice to code the permissions somewhere, then generate the grant statements as required. Signed-off-by: Jeremy Kerr --- lib/sql/grant-all.sql | 69 --------------------------------------------------- 1 file changed, 69 deletions(-) delete mode 100644 lib/sql/grant-all.sql (limited to 'lib/sql/grant-all.sql') diff --git a/lib/sql/grant-all.sql b/lib/sql/grant-all.sql deleted file mode 100644 index 72e1f31..0000000 --- a/lib/sql/grant-all.sql +++ /dev/null @@ -1,69 +0,0 @@ -BEGIN; --- give necessary permissions to the web server. Becuase the admin is all --- web-based, these need to be quite permissive -GRANT SELECT, UPDATE, INSERT, DELETE ON - auth_message, - django_session, - django_site, - django_admin_log, - django_content_type, - auth_group_permissions, - auth_user, - auth_user_groups, - auth_group, - auth_user_user_permissions, - auth_permission, - patchwork_userpersonconfirmation, - patchwork_state, - patchwork_comment, - patchwork_person, - patchwork_userprofile, - patchwork_userprofile_maintainer_projects, - patchwork_project, - patchwork_bundle, - patchwork_bundle_patches, - patchwork_patch, - registration_registrationprofile -TO "www-data"; -GRANT SELECT, UPDATE ON - auth_group_id_seq, - auth_group_permissions_id_seq, - auth_message_id_seq, - auth_permission_id_seq, - auth_user_groups_id_seq, - auth_user_id_seq, - auth_user_user_permissions_id_seq, - django_admin_log_id_seq, - django_content_type_id_seq, - django_site_id_seq, - patchwork_bundle_id_seq, - patchwork_bundle_patches_id_seq, - patchwork_comment_id_seq, - patchwork_patch_id_seq, - patchwork_person_id_seq, - patchwork_project_id_seq, - patchwork_state_id_seq, - patchwork_userpersonconfirmation_id_seq, - patchwork_userprofile_id_seq, - patchwork_userprofile_maintainer_projects_id_seq, - registration_registrationprofile_id_seq -TO "www-data"; - --- allow the mail user (in this case, 'nobody') to add patches -GRANT INSERT, SELECT ON - patchwork_patch, - patchwork_comment, - patchwork_person -TO "nobody"; -GRANT SELECT ON - patchwork_project, - patchwork_state -TO "nobody"; -GRANT UPDATE, SELECT ON - patchwork_patch_id_seq, - patchwork_person_id_seq, - patchwork_comment_id_seq -TO "nobody"; - -COMMIT; - -- cgit v1.2.3