ReadOnly user

athisivan

I want to know the Livelink users who has only "See" and "See Contents" permission on Livelink Items. In other words, the list of Livelink Users who has not any Modify permission on Livelink Items.

Can anyone help on this?

CBancroft

Here is a possible oracle query that will give users and their permissions (public access (see, see contents), etc.

Public Access is basically the same as a ‘Read Only’ user.

 

select LastName,

FirstName,

name as UserID,

Department.Name as Department,

(CASE WHEN mod((UserPrivileges/1), 2) = 1 then 'Yes' else ' ' END)

As LoginEnabled,

(CASE WHEN mod((UserPrivileges/2048),2) = 1 then 'Yes' else ' ' END)

As PublicAccess,

(CASE WHEN mod((UserPrivileges/32),2) = 1 then 'Yes' else ' ' END)

As CreateUsers,

(CASE WHEN mod((UserPrivileges/64),2) = 1 then 'Yes' else ' ' END)

As CreateGroups,

(CASE WHEN mod((UserPrivileges/16),2) = 1 then 'Yes' else ' ' END)

As UserAdmin,

(CASE WHEN mod((UserPrivileges/256),2) = 1 then 'Yes' else ' ' END)

As SystemAdmin

FROM kuaf LLUser

INNER JOIN kuaf Department

ON GroupID = Department.ID

WHERE Deleted = 0

AND (mod((UserPrivileges/32),2) = 1

OR mod((UserPrivileges/64),2) = 1

OR mod((UserPrivileges/16),2) = 1

OR mod((UserPrivileges/256),2) = 1

) ORDER BY LastName, FirstName 

 

You can translate to MSSQL  syntax if needed

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, May 03, 2017 9:19 AM
To: eLink Recipient
Subject: ReadOnly user

 

ReadOnly user

Posted by Sivan, Athisivan On 05/03/2017 09:11 AM

 

I want to know the Livelink users who has only "See" and "See Contents" permission on Livelink Items. In other words, the list of Livelink Users who has not any Modify permission on Livelink Items. Can anyone help on this?

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16