Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- d.dataid "Folder ID",
- dfp.fullpath "Path",
- d.name "Folder Name",
- k.name "Group",
- acl.PERM_LIST "Permissions"
- FROM
- dtree d
- join dtreeancestors da on d.dataid = da.dataid and da.ancestorid = 44411414 AND d.subtype IN (0,751)
- JOIN
- lrer_fullpath dfp
- ON
- dfp.dataid = d.dataid
- JOIN
- lrer_dtreeacl acl
- ON
- d.dataid = acl.DATAID
- JOIN
- kuaf k
- ON
- acl.RIGHTID = k.id
- AND k.type = 1
- ORDER BY
- dfp.fullpath,
- k.name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement