SHARE
TWEET

Untitled

a guest Oct 21st, 2019 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     d.dataid     dataid,
  3.     dfp.fullpath "Path",
  4.     d.name,
  5.     k.name        "Group",
  6.     acl.PERM_LIST "Permissions"
  7. FROM
  8.     dtree d
  9. join dtreeacl da on d.dataid = da.dataid and da.ancestorid = %1 AND d.subtype=0
  10.  
  11. JOIN
  12.     lrer_fullpath dfp
  13. ON
  14.     dfp.dataid = d.dataid
  15. JOIN
  16.     lrer_dtreeacl acl
  17. ON
  18.     d.dataid = acl.DATAID
  19. JOIN
  20.     kuaf k
  21. ON
  22.     acl.RIGHTID = k.id
  23. AND k.type = 1
  24. AND k.name = %2
  25. ORDER BY
  26.     d.dataid,
  27.     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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top