KUAF differences between 9.0 and 9.1?

Not sure if this is the right discussion, so let me know if not.We use KUAF information to see the status of users (so disabled, admin, able to edit users, etc.). In the database these statuses are represented by values (14, 15, etc.).I recently got the results for a 9.1 server and noticed that there are a lot of different values in that list. So before I am going to combine the 9.0 results with the 9.1 results I'd like to know if these values have been changed in the new version?If so, my preference would be to have a list of 'old' values compared with a list of 'new' values.If this post does not make sense, please let me know as well

Find more posts tagged with

Comments

eLink User

Message from Daniel Couto via eLinkThere is (at least) one new value: In LL9.1 there's the new "Public Access"permission, that adds up 2048 to the status value.Cheers,Daniel-----Original Message-----From: eLink Discussion: Development Discussion[mailto:development@elinkkc.opentext.com]Sent: Friday, August 09, 2002 3:32 PMTo: eLink RecipientSubject: KUAF differences between 9.0 and 9.1?KUAF differences between 9.0 and 9.1?Posted by UnileverAdmin on 08/09/2002 09:25 AMNot sure if this is the right discussion, so let me know if not.We use KUAF information to see the status of users (so disabled, admin, ableto edit users, etc.). In the database these statuses are represented byvalues (14, 15, etc.).I recently got the results for a 9.1 server andnoticed that there are a lot of different values in that list. So before Iam going to combine the 9.0 results with the 9.1 results I'd like to know ifthese values have been changed in the new version?If so, my preference would be to have a list of 'old' values compared with alist of 'new' values.If this post does not make sense, please let me know as well

[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Development Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=786303&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

eLink User

Message from David Slimmon via eLinkHi there,I can offer you half of what you're looking for with a homegrown list I madeone time when I was trying to figure it out. Usual disclaimers apply, thisisn't an official document from Open Text, unless you count crummy littletxt files that sit on my hard drive as official documents.Might be handy for people though. To get it up to date with all the newprivileges probably wouldn't take much time and when I have a few hours tokill some time I'll probably get around to it, although it would be great ifsomebody else already had that info out there somewhere.See attached user_privileges.txtRegards,David___________________________________________O P E N T E X T C O R P O R A T I O NDavid Slimmon, M.L.I.S.Knowledge Managerhttps://knowledge.opentext.comdslimmon@opentext.com-----Original Message-----From: eLink Discussion: Development Discussion[mailto:development@elinkkc.opentext.com]Sent: Friday, August 09, 2002 9:32 AMTo: eLink RecipientSubject: KUAF differences between 9.0 and 9.1?KUAF differences between 9.0 and 9.1?Posted by UnileverAdmin on 08/09/2002 09:25 AMNot sure if this is the right discussion, so let me know if not.We use KUAF information to see the status of users (so disabled, admin, ableto edit users, etc.). In the database these statuses are represented byvalues (14, 15, etc.).I recently got the results for a 9.1 server andnoticed that there are a lot of different values in that list. So before Iam going to combine the 9.0 results with the 9.1 results I'd like to know ifthese values have been changed in the new version?If so, my preference would be to have a list of 'old' values compared with alist of 'new' values.If this post does not make sense, please let me know as well

Steve_McDonough

We're a new user to Livelink so I don't have any information on the privileges codes under 9.0. I put together this spreadsheet of all the possible combinations and their codes under 9.1. Being new, I'm hoping that I calculated these codes correctly. Therefore, use what is in the spreadsheet as a guide. Hope it helps!

Silke_Pelzer_(uniadmin_-_(deleted))

Thanks for the lists.If you compare them you can actually see that an option "Public Access enabled" was added as a privilege. Therefor the XLS posted by Leon is valid for both 9.0 and 9.1.Cheers,Eric

Harald_Lange_(harald.lange@nsn.com_(Delete)_231178

Thanks, Leon !;o)

Tim_Hunter

SELECT u.id ,u.Name "UserID" ,u.Firstname || ' ' || u.LastName "FullName" ,u.Mailaddress "EmailAddress" ,d.CreateDate "CreateDate" ,g.Name "DepartmentGroup" ,(CASE WHEN mod(floor(u.UserPrivileges/1), 2) = 1 then 'Login' else null END)|| (CASE WHEN mod(floor(u.UserPrivileges/2048),2) = 1 then '+PublicAccess' else null END)|| (CASE WHEN mod(floor(u.UserPrivileges/32),2) = 1 then '+CreateUsers' else null END)|| (CASE WHEN mod(floor(u.UserPrivileges/64),2) = 1 then '+CreateGroups' else null END)|| (CASE WHEN mod(floor(u.UserPrivileges/16),2) = 1 then '+UserAdmin' else null END)|| (CASE WHEN mod(floor(u.UserPrivileges/256),2) = 1 then '+SystemAdmin' else null END) as Privs ,u.UserPrivileges "Permissions" FROM Kuaf u , DTree d , Kuaf g WHERE u.id = %1 AND u.deleted=0 AND u.type=0 AND u.GroupID=g.ID AND (u.ID=d.USERID AND d.dataID=createdby)order by g.name, u.Mailaddress