Hello all,
For a search application we want to present a document as download when the user has LiveLink access (READ or higher permission). The question is for retrieving permission for a specific user on a document. Is there a LAPI method which I can use?
Furthermore I have database access and was trying to find the permissions based on the KUAF and DTREE tables. The following is what I’ve tried.
- Get the user id and user group id from KUAF table
- Get the groups belonging to the objId (document id) DTREE & DTREEACL
- Recursive loop through all groups (retrieved in step 2) until the user (or user group) is found. The relations in KUAFCHILDREN are used for this recursive query. (Both directions tried, parent -> child and child -> parent)
The query above doesn't find a match. I’m sure the user has access but the match is not found. Could this be because the LL instance is public (DTREEACL.RIGHTID == -1)?
Resume, could someone help me out with a LAPI method I’ve missed or a query to retrieve the mapping on a document for a given user so that I'm sure that the user has access to that document?