lib: add missing permissions for patchwork_comment_id_seq · getpatchwork/patchwork@f7bb805 · GitHub

getpatchwork / patchwork Public

• Notifications You must be signed in to change notification settings
• Fork 90
• Star 316

• Code
• Issues 97
• Pull requests 22
• Actions
• Security and quality
• Insights

Additional navigation options

Commit f7bb805

Browse filesBrowse the repository at this point in the historyBrowse files

alialnu

authored and

stephenfin

committed

lib: add missing permissions for patchwork_comment_id_seq

Grants UPDATE and SELECT privileges on patchwork_comment_id_seq table for web and mail users to fix the following exception when comments are parsed: django.db.utils.ProgrammingError: permission denied for sequence patchwork_comment_id_seq Fixes: 5b53f46 ("lib: fix table names") Signed-off-by: Ali Alnubani <alialnu@nvidia.com>

1 parent 8a96062 commit f7bb805
Copy full SHA for f7bb805

1 file changed

+2Lines changed: 2 additions & 0 deletions

File tree

Expand file treeCollapse file tree

Open diff view settings

Filter options

• lib/sql
  • grant-all.postgres.sql

Expand file treeCollapse file tree

Open diff view settings

Collapse file

‎lib/sql/grant-all.postgres.sql‎

Copy file name to clipboardExpand all lines: lib/sql/grant-all.postgres.sql

+2Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
@@ -49,6 +49,7 @@ GRANT SELECT, UPDATE ON
49	49	patchwork_bundle_id_seq,
50	50	patchwork_bundlepatch_id_seq,
51	51	patchwork_check_id_seq,
	52	+ patchwork_comment_id_seq,
52	53	patchwork_cover_id_seq,
53	54	patchwork_covercomment_id_seq,
54	55	patchwork_delegationrule_id_seq,
@@ -91,6 +92,7 @@ GRANT SELECT ON
91	92	patchwork_tag
92	93	TO "nobody";
93	94	GRANT UPDATE, SELECT ON
	95	+ patchwork_comment_id_seq,
94	96	patchwork_event_id_seq,
95	97	patchwork_patch_id_seq,
96	98	patchwork_patchtag_id_seq,

0 commit comments

Comments

0 (0)