SHARE
TWEET

Untitled

a guest Oct 21st, 2019 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     d.dataid "Folder ID",
  3.     dfp.fullpath "Path",
  4.     d.name "Folder Name",
  5.     k.name        "Group",
  6.     acl.PERM_LIST "Permissions"
  7. FROM
  8.     dtree d
  9. join dtreeancestors da on d.dataid = da.dataid and da.ancestorid = 44411414 AND d.subtype IN (0,751)
  10. JOIN
  11.     lrer_fullpath dfp
  12. ON
  13.     dfp.dataid = d.dataid
  14. JOIN
  15.     lrer_dtreeacl acl
  16. ON
  17.     d.dataid = acl.DATAID
  18. JOIN
  19.     kuaf k
  20. ON
  21.     acl.RIGHTID = k.id
  22. AND k.type = 1
  23. ORDER BY
  24.     dfp.fullpath,
  25.     k.name
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top