When should I update both dtreeacl and dtree?

I'm using Livelink 8.1.3 and SQL7.I want to update the permission of one of the usergroups in a document. I don't know whether update the dtreeacl table is enough for updating. And I also want to update the permission of one of the usergroup in a folder which contains many documents. In this condition, should I update both dtreeacl and dtree table?Any help is appreciated.Shirley

Find more posts tagged with

Comments

Bob_De_Garmo_(degarmob_(Delete)_2518944)

I, for one, sure hope you're not talking about updating those tables directly via SQL! I also believe that OT Support will vehemently concur with that...Permissions are tricky things at best, and hacking them via SQL << especially in SQL Server >> is pretty scarey stuff!My opinion? Use the Livelink interface... Even if you have to buy Pizza, and spend an evening doing it. If you hack 'em, and things go awry, you may NEVER be able to get back to the folders/docs again...In my humble opinion...

Shirley_Xie_(xie_(Delete)_1422527)

I haven't touch the real data yet. I tried one test document and assigned 5 usergroups for it. Then change one of them by using:update dtreeacl set permissions = 258203 where acltype = 0 and rightid = 877172 and dataid = 1523030It works. But I need to update the 'see' field too.So what other tables are connected? And why the things go away as you mention?Thanks for you opinion.Shirley

eLink User

Message from Alex Kowalenko via eLinkI would agree with this opinion. I'll be discussing this issue and many morein my course, U-TR-209 (Livelink Schema and Advanced LiveReports), at theLivelinkUp 2001 user conference on Tuesday November 6, 2001. To seeregistration information and descriptions of this and other courses offeredat the user conference please go to this web site:http://www.opentext.com/livelinkup/training/TimeTable.html#-----Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Wednesday, October 10, 2001 12:05To: eLink RecipientSubject: I, for one, sure hope you're not talking about updating thosetables directly...I, for one, sure hope you're not talking about updating those tablesdirectly...Posted by degarmob on 10/10/2001 12:04 PMI, for one, sure hope you're not talking about updating those tablesdirectly via SQL! I also believe that OT Support will vehemently concurwith that...Permissions are tricky things at best, and hacking them via SQL <<especially in SQL Server >> is pretty scarey stuff!My opinion? Use the Livelink interface... Even if you have to buy Pizza,and spend an evening doing it. If you hack 'em, and things go awry, you mayNEVER be able to get back to the folders/docs again...In my humble opinion...[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: When should I update both dtreeacl and dtree?https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2600027&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

John W. Simon, Jr.

Shirley,The best way to do this would be through builder. That is because you tell builder to make the permission change and it changes all of the tables it needs to. However, if you don't have access to builder and don't want to spend hours using the GUI to affect these changes (if there were say thousands of records), you can update the tables directly.1). Keep in mind that each object in Livelink is one row in dtree and many rows in dtreeacl.2). You shouldn't have to update dtree unless you change permissions for the owner, owner group, public, and/or Admin (acltype 1,2,3,4). If you have to change one of these permissions then you will need to update upermissions, gpermissions, wpermissions, and/or spermissions in dtree.Regards,John Simon