"SET" permission report

Birger_Jacobsen_(danskadmin_-_(deleted))

I need help to create a report changing permission to a folder AND its content (subfolders & documents). I have been looking at the DtreeAcl and Dtree tabels, tryed few posibilities but without succesUpdate DTREEACL Set DTREEACL.PERMISSIONS=%1 WHERE DTREEACL.DATAID=%2 AND DTREEACL.RIGHTID=%3This report works fin , but only for one folder (par.%2)%1 = Permissions%3 = gr.IDAny help will be apreciated thanks

Find more posts tagged with

Comments

Marie_Lindsay_(MLindsay_(Delete)_15608)

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

This is a scary kind of thing to do, so I wonder: What's your motivation for doing this via SQL instead of via the Livelink interface?

(Always good to understand the requirements, in hopes of improving the product)

Thanks,

Marie Lindsay

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, August 15, 2003 8:47 AM
To: eLink Recipient
Subject: "SET" permission report

"SET" permission report Posted by DanskAdmin (Souary, Idriss) on 08/15/2003 09:47 AM

I need help to create a report changing permission to a folder AND its content (subfolders & documents). I have been looking at the DtreeAcl and Dtree tabels, tryed few posibilities but without succes

Update DTREEACL Set DTREEACL.PERMISSIONS=%1 WHERE DTREEACL.DATAID=%2 AND DTREEACL.RIGHTID=%3

This report works fin , but only for one folder (par.%2)
%1 = Permissions
%3 = gr.ID

Any help will be apreciated thanks

Birger_Jacobsen_(danskadmin_-_(deleted))

We have committees folders which contains up to 20 subfolders, users can only see some subfolders but not all, depending of there rolle. LL interfaces does allow you to apply 36995 perms to some subfolders and 128 perms to other on the fly (Unless you tell me something I don´t know ), you must apply the rights to all the subfolders and then to remove them for some of them. My report allow me to type the name of the group, the name of the folder to which 36995 or 128 rights must apply. Currently I must still repeat the report for each subfolder but its still a little faster than the interface of LL, which requires about 20 mouse clicks

Marie_Lindsay_(MLindsay_(Delete)_15608)

Message from Marie Lindsay <<A HREF="mailto:marie@opentext.com">marie@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Thanks very much for this explanation -- I can see where the difficulty lies. I'll make sure that this "test case" gets passed along to Development.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, August 18, 2003 3:15 AM
To: eLink Recipient
Subject: "SET" permission report

"SET" permission report Posted by DanskAdmin (Souary, Idriss) on 08/18/2003 04:13 AM
In reply to: RE "SET" permission report Posted by MLindsay (Lindsay, Marie) on 08/15/2003 10:18 AM

We have committees folders which contains up to 20 subfolders, users can only see some subfolders but not all, depending of there rolle. LL interfaces does allow you to apply 36995 perms to some subfolders and 128 perms to other on the fly (Unless you tell me something I don´t know ), you must apply the rights to all the subfolders and then to remove them for some of them. My report allow me to type the name of the group, the name of the folder to which 36995 or 128 rights must apply. Currently I must still repeat the report for each subfolder but its still a little faster than the interface of LL, which requires about 20 mouse clicks

Valerie_Beaver

We have a need to change an attribute value on a set of documents and then add a new group for access to that same set of documents, possibly changing privileges on existing users/groups. Should this best be accomplished through a LiveReport?