{"id":614,"date":"2016-10-17T08:21:11","date_gmt":"2016-10-17T06:21:11","guid":{"rendered":"https:\/\/blog.4-it.net\/?p=614"},"modified":"2016-10-17T08:23:54","modified_gmt":"2016-10-17T06:23:54","slug":"owncloud-unshare-reshare-geteilter-ordner","status":"publish","type":"post","link":"https:\/\/blog.4-it.net\/?p=614","title":{"rendered":"owncloud &#8222;unshare&#8220; &#8222;reshare&#8220; geteilter Ordner"},"content":{"rendered":"<p>Falls ein User einen Ordner \u00fcber die Funktion Unshare aus seinem Account verbannt, kann dieser nur \u00fcber ein SQL Statement zur\u00fcckgewonnen werden.<\/p>\n<p><a href=\"https:\/\/blog.4-it.net\/wp-content\/uploads\/2016\/10\/2016-10-17_08h13_08.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-615 size-thumbnail\" src=\"https:\/\/blog.4-it.net\/wp-content\/uploads\/2016\/10\/2016-10-17_08h13_08-150x150.png\" alt=\"2016-10-17_08h13_08\" width=\"150\" height=\"150\" srcset=\"https:\/\/blog.4-it.net\/wp-content\/uploads\/2016\/10\/2016-10-17_08h13_08-150x150.png 150w, https:\/\/blog.4-it.net\/wp-content\/uploads\/2016\/10\/2016-10-17_08h13_08.png 248w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a><\/p>\n<blockquote>\n<pre>select * from oc_share where permissions=0 and share_type=2<\/pre>\n<p>Dieses Statement muss auf die DB der owncloud ausgef\u00fchrt und dann die Tabelle oc_share ausgew\u00e4hlt werden.<br \/>\nAnschlie\u00dfend noch nach &#8222;permissions&#8220; sortieren, und schon sieht man die &#8222;\u00dcbelt\u00e4ter&#8220;<br \/>\n(mit permissions 0 und share_tpye 2=<br \/>\nEinfach dann die gesamte Zeile (siehe Beispiel) l\u00f6schen.<\/p>\n<p><a href=\"https:\/\/blog.4-it.net\/wp-content\/uploads\/2016\/10\/2016-10-17_08h18_01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-618 size-medium\" src=\"https:\/\/blog.4-it.net\/wp-content\/uploads\/2016\/10\/2016-10-17_08h18_01-300x19.png\" alt=\"2016-10-17_08h18_01\" width=\"300\" height=\"19\" srcset=\"https:\/\/blog.4-it.net\/wp-content\/uploads\/2016\/10\/2016-10-17_08h18_01-300x19.png 300w, https:\/\/blog.4-it.net\/wp-content\/uploads\/2016\/10\/2016-10-17_08h18_01-768x49.png 768w, https:\/\/blog.4-it.net\/wp-content\/uploads\/2016\/10\/2016-10-17_08h18_01-1024x65.png 1024w, https:\/\/blog.4-it.net\/wp-content\/uploads\/2016\/10\/2016-10-17_08h18_01.png 1653w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>L\u00f6schen kann auch mit folgendem Statement ausgef\u00fchrt werden wenn die ID bekannt ist<\/p>\n<pre>DELETE FROM `owncloud`.`oc_share` WHERE `oc_share`.`id` = 1130\"<\/pre>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Falls ein User einen Ordner \u00fcber die Funktion Unshare aus seinem Account verbannt, kann dieser nur \u00fcber ein SQL Statement zur\u00fcckgewonnen werden. select * from oc_share where permissions=0 and share_type=2 Dieses Statement muss auf die DB der owncloud ausgef\u00fchrt und dann die Tabelle oc_share ausgew\u00e4hlt werden. Anschlie\u00dfend noch nach &#8222;permissions&#8220; sortieren, und schon sieht man [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-614","post","type-post","status-publish","format-standard","hentry","category-tools"],"_links":{"self":[{"href":"https:\/\/blog.4-it.net\/index.php?rest_route=\/wp\/v2\/posts\/614","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.4-it.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.4-it.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.4-it.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.4-it.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=614"}],"version-history":[{"count":5,"href":"https:\/\/blog.4-it.net\/index.php?rest_route=\/wp\/v2\/posts\/614\/revisions"}],"predecessor-version":[{"id":623,"href":"https:\/\/blog.4-it.net\/index.php?rest_route=\/wp\/v2\/posts\/614\/revisions\/623"}],"wp:attachment":[{"href":"https:\/\/blog.4-it.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.4-it.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=614"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.4-it.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}