User Privileges Possible Values

Hello,I found a document outlining all the possible values for KUAF.UserPrivileges. It was a very handy document when writing reports regarding priveleges. It is rather dated now since it only outlines possibilities when Livelink only had four option boxes. 1 - Log in enabled2 - Can create/modify users3 - Can create/modify groups4 - User administration accessDoes anyone have a recent document outlining the possible values to include Public Access and System admin rights?Thanks,Julie

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

See the Excel document attached to this post, and let me know if it helps.

https://knowledge.opentext.com/knowledge/llisapi.dll/open/14505127

- Bhupinder
----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, December 02, 2008 6:29 PM
To: eLink Recipient
Subject: User Privileges Possible Values

User Privileges Possible Values

Posted by jcronk (Cronk, Julie) on 12/02/2008 06:28 PM

Hello,

I found a document outlining all the possible values for KUAF.UserPrivileges. It was a very handy document when writing reports regarding priveleges. It is rather dated now since it only outlines possibilities when Livelink only had four option boxes.

1 - Log in enabled
2 - Can create/modify users
3 - Can create/modify groups
4 - User administration access

Does anyone have a recent document outlining the possible values to include Public Access and System admin rights?

Thanks,
Julie

Julie_Cronk

Message from Julie Cronk <jcronk@opentext.com> via eLink

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

Ahhh Perfect...

Thank you very much, greatly appreciated!

Julie

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, December 02, 2008 6:41 PM
To: eLink Recipient
Subject: RE User Privileges Possible Values

RE User Privileges Possible Values		Posted by bsingh (Singh, Bhupinder) on 12/02/2008 07:40 PM
In reply to: User Privileges Possible Values		Posted by jcronk (Cronk, Julie) on 12/02/2008 06:28 PM

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

See the Excel document attached to this post, and let me know if it helps. https://knowledge.opentext.com/knowledge/llisapi.dll/open/14505127 - Bhupinder
----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, December 02, 2008 6:29 PM
To: eLink Recipient
Subject: User Privileges Possible Values

User Privileges Possible Values

Posted by jcronk (Cronk, Julie) on 12/02/2008 06:28 PM

Hello,

I found a document outlining all the possible values for KUAF.UserPrivileges. It was a very handy document when writing reports regarding priveleges. It is rather dated now since it only outlines possibilities when Livelink only had four option boxes.

1 - Log in enabled
2 - Can create/modify users
3 - Can create/modify groups
4 - User administration access

Does anyone have a recent document outlining the possible values to include Public Access and System admin rights?

Thanks,
Julie

Jim_Coursey

Message from Coursey, Jim <jim.coursey@ngc.com> via eLink

eLink

Log-in enabled Public Access enabled Can create/modify users Can create/modify groups User administration rights System administration rights

Tim_Hunter

FYI here is a query (Oracle) I use for a report, set prompt for useridSELECT u.id,u.Name "UserID",u.firstname || case when length(u.middlename) > 0 then ' ' ||substr(u.middlename,1,1) || '. ' else ' ' end || 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 = %1AND u.deleted=0AND u.type=0 AND u.GroupID=g.IDAND (u.ID=d.USERID AND d.dataID=createdby)order by g.name, u.Mailaddress

Jeff_Brown_(G*_ECM_Champ)

Message from Brown, Jeff via eLinkGreg Griffiths has an excellent (and free) tool on his website to decode the permissions into a Excel spreadsheet. Very easy to use.http://greggriffiths.org/livelink/addons/permissionsdecoder/-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wed 12/3/2008 9:51 AMTo: eLink RecipientSubject: User Privileges query User Privileges query Posted by timothy.hunter.ctr@wpafb.af.mil (Hunter, Tim ) on 12/03/2008 09:47 AM In reply to: RE User Privileges Possible Values 2 Posted by grmmun02user8 (Coursey, Jim) on 12/03/2008 07:43 AM FYI here is a query (Oracle) I use for a report, set prompt for useridSELECT u.id,u.Name "UserID",u.firstname || case when length(u.middlename) > 0 then ' ' ||substr(u.middlename,1,1) || '. ' else ' ' end || 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 = %1AND u.deleted=0AND u.type=0 AND u.GroupID=g.IDAND (u.ID=d.USERID AND d.dataID=createdby)order by g.name, u.Mailaddress ________________________________[To reply to this thread, use your normal E-mail reply function.] Topic: User Privileges Possible Values Discussion: Livelink LiveReports Discussion Livelink Server: knowledge-wlweb01 To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com . *****************************NOTICE - This message is intended only for the use of the individual or entity to which it is addressed and may contain information which is privileged, confidential or proprietary. Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, arrive late or contain viruses. By communicating with us via e-mail, you accept such risks. When addressed to our clients, any information, drawings, opinions or advice (collectively, "information") contained in this e-mail is subject to the terms and conditions expressed in the governing agreements. Where no such agreement exists, the recipient shall neither rely upon nor disclose to others, such information without our written consent. Unless otherwise agreed, we do not assume any liability with respect to the accuracy or completeness of the information set out in this e-mail. If you have received this message in error, please notify us immediately by return e-mail and destroy and delete the message from your computer.