FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
patchwork/lib/sql/grant-all.postgres.sql at stable/3.2 · getpatchwork/patchwork · GitHub
Uh oh!
There was an error while loading.
Please reload this page
.
getpatchwork
/
patchwork
Public
Notifications
You must be signed in to change notification settings
Fork
90
Star
315
Code
Issues
97
Pull requests
22
Actions
Security and quality
0
Insights
Additional navigation options
Code
Issues
Pull requests
Actions
Security and quality
Insights
Expand file tree
Breadcrumbs
patchwork
/
lib
/
sql
/
grant-all.postgres.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
106 lines (104 loc) · 2.54 KB
Breadcrumbs
patchwork
/
lib
/
sql
/
grant-all.postgres.sql
Copy path
File metadata and controls
106 lines (104 loc) · 2.54 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
BEGIN
;
--
give necessary permissions to the web server. Because the admin is all
--
web-based, these need to be quite permissive
GRANT
SELECT
,
UPDATE
, INSERT,
DELETE
ON
auth_group,
auth_group_permissions,
auth_user,
auth_user_groups,
auth_user_user_permissions,
auth_permission,
authtoken_token,
django_admin_log,
django_content_type,
django_session,
django_site,
patchwork_bundle,
patchwork_bundlepatch,
patchwork_check,
patchwork_cover,
patchwork_covercomment,
patchwork_delegationrule,
patchwork_emailconfirmation,
patchwork_emailoptout,
patchwork_event,
patchwork_patch,
patchwork_patchchangenotification,
patchwork_patchcomment,
patchwork_patchrelation,
patchwork_patchtag,
patchwork_person,
patchwork_project,
patchwork_series,
patchwork_seriesreference,
patchwork_state,
patchwork_tag,
patchwork_userprofile,
patchwork_userprofile_maintainer_projects
TO
"
www-data
"
;
GRANT
SELECT
,
UPDATE
ON
auth_group_id_seq,
auth_group_permissions_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_bundlepatch_id_seq,
patchwork_check_id_seq,
patchwork_comment_id_seq,
patchwork_cover_id_seq,
patchwork_covercomment_id_seq,
patchwork_delegationrule_id_seq,
patchwork_emailconfirmation_id_seq,
patchwork_event_id_seq,
patchwork_patch_id_seq,
patchwork_patchrelation_id_seq,
patchwork_patchtag_id_seq,
patchwork_person_id_seq,
patchwork_project_id_seq,
patchwork_series_id_seq,
patchwork_seriesreference_id_seq,
patchwork_state_id_seq,
patchwork_tag_id_seq,
patchwork_userprofile_id_seq,
patchwork_userprofile_maintainer_projects_id_seq
TO
"
www-data
"
;
--
allow the mail user (in this case, 'nobody') to add patches
--
cover letters, their respective comments, and series
GRANT
INSERT,
SELECT
ON
patchwork_cover,
patchwork_covercomment,
patchwork_patch,
patchwork_patchcomment,
patchwork_event,
patchwork_seriesreference
TO
"
nobody
"
;
GRANT
INSERT,
SELECT
,
UPDATE
,
DELETE
ON
patchwork_patch,
patchwork_patchtag,
patchwork_person,
patchwork_series
TO
"
nobody
"
;
GRANT
SELECT
ON
auth_user,
patchwork_delegationrule,
patchwork_project,
patchwork_state,
patchwork_tag
TO
"
nobody
"
;
GRANT
UPDATE
,
SELECT
ON
patchwork_comment_id_seq,
patchwork_cover_id_seq,
patchwork_covercomment_id_seq,
patchwork_event_id_seq,
patchwork_patch_id_seq,
patchwork_patchtag_id_seq,
patchwork_person_id_seq,
patchwork_series_id_seq,
patchwork_seriesreference_id_seq
TO
"
nobody
"
;
COMMIT
;
Back
|
FazBrowse Home
|
New Git URL