<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang=EN-US link=blue vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span lang=SR-LATN-RS>Hi Paolo,<o:p></o:p></span></p><p class=MsoNormal><span lang=SR-LATN-RS><o:p> </o:p></span></p><p class=MsoNormal><span lang=SR-LATN-RS>I also have a problem with bulk update document permission. But there is a option in admin page to add some permission on documents but it seems that does not work. Maybe you could give a try<o:p></o:p></span></p><p class=MsoNormal><span lang=SR-LATN-RS><o:p> </o:p></span></p><p class=MsoNormal><img width=1057 height=361 style='width:11.0104in;height:3.7604in' id="Picture_x0020_3" src="cid:image003.png@01D7DC78.2F714E60"><span lang=SR-LATN-RS><o:p></o:p></span></p><p class=MsoNormal><span lang=SR-LATN-RS><o:p> </o:p></span></p><p class=MsoNormal>Also,</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have added in .env </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>DEFAULT_ANONYMOUS_VIEW_PERMISSION=False</p><p class=MsoNormal>DEFAULT_ANONYMOUS_DOWNLOAD_PERMISSION=False</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>To ensure that all new content is forbiden for non registered users.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986">Mail</a> for Windows</p><p class=MsoNormal><o:p> </o:p></p><div style='mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='border:none;padding:0in'><b>From: </b><a href="mailto:paolo.pasquali@gmail.com">Paolo Pasquali</a><br><b>Sent: </b>Thursday, November 18, 2021 11:56 <br><b>To: </b><a href="mailto:geonode-devel@lists.osgeo.org">geonode-devel</a><br><b>Subject: </b>Re: [GeoNode-devel] Bulk permissions for Documents</p></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Hi Devs,</p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>It seems I can achieve my goal by deleting some records in the geonode db. I know it is quite dangerous so I'm posting it here for advice from you.</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>So, for instance, if I want to remove the capability to download uploaded documents by non-registered users I should:<o:p></o:p></p></div><div><p style='margin:0in;font-stretch:normal'><span style='font-family:"Courier New";color:black'>DELETE FROM guardian_userobjectpermission WHERE object_pk = '523' AND permission_id = 162 AND user_id = '-1';</span><span style='color:black'><o:p></o:p></span></p></div><div><p style='margin:0in;font-stretch:normal'><span style='font-family:"Courier New";color:black'>DELETE FROM guardian_groupobjectpermission WHERE object_pk = '523' AND permission_id = 162 AND group_id = '1';</span><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Where 523 is one of the document I want to change the permissions and 162 is the download permission. Starting from this query I can change permissions in bulk.</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Is it safe to proceed this way or is there a management command for documents I can use?</p></div><div><p class=MsoNormal>Thanks!</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Bye,</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>P.</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Wed, Nov 17, 2021 at 5:14 PM Paolo Pasquali <<a href="mailto:paolo.pasquali@gmail.com">paolo.pasquali@gmail.com</a>> wrote:</p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><p class=MsoNormal>Dear devs,</p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I would like to set permissions in bulk for documents. For instance, I'd like that only a certain users group can download some documents or unregistered users cannot download any document.</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>While the cart is available on the layers page only, I wonder if the set_layers_permissions command [1] can be used on the documents as well. It seems not.</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Any suggestion on how to proceed?</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Thanks for your help.</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Ciao</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Paolo</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div></blockquote></div><p class=MsoNormal style='margin-left:4.8pt'>[1] <a href="https://docs.geonode.org/en/master/admin/mgmt_commands/index.html#batch-sync-permissions">https://docs.geonode.org/en/master/admin/mgmt_commands/index.html#batch-sync-permissions</a></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>