Advertisement
Guest User

Untitled

a guest
Oct 21st, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. SELECT d.dataid dataid, dfp.fullpath "Path", d.name, k.name "Group", acl.PERM_LIST "Permissions"FROM dtree d join lrer_fullpath dfp on dfp.dataid = d.dataid JOIN lrer_dtreeacl acl ON d.dataid = acl.DATAID AND d.subtype=0 AND d.ownerid = -2000 JOIN kuaf k ON acl.RIGHTID = k.id AND k.type = 1 AND k.name IN ('AEB ALL USERS -- VE USAGERS-TOUS', 'CB ALL USERS -- BC USAGERS-TOUS', 'CIPO ALL USERS -- OPIC USAGERS-TOUS', 'IS ALL USERS -- SI USAGERS-TOUS', 'IS MLSB ALL USERS -- SI DGFSV USAGERS-TOUS') ORDER BY d.dataid, k.name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement