How to write a sql if I want filter permission?

Viktoria_Svensson_(sablinuser2_-_(deleted))

I want to write a sql out of Livelink and use "filter permission".I try to write a sql which select the dokument a specific user is owner of. Then change the owner to another user.But the person who runs the report just has to see the documents that he has the permission to "edit permission" for. I have to know if he's userid is in the column rightid in the dtreeacl table and if he's group has the permission to edit permission of the document.This is really tricky!!!

Find more posts tagged with

Comments

Janusz_Frydecki

I once did a SQL query that tried to retrieve every user having write access in LL. This script is Oracle specific. If you'Re also using Oracle, I'm sure you could find some tracks in it. BTW, don'T try to run it directly or you'll have a big risk of crashing you DB.If you have questions, feel free to ask

Stefan_Becker_(stefanbecker_-_(deleted))

If you are using oracle this is an easy connect by prior through the kuafchildren table.To check the acl entries you found for edit permission you can use mod(floor(da.permissions/16),2) = 1on oracle or something similar on another database(da = dtreeacl)