Report to show which users have rights given to their account?

When a user is created they are given the following options:Log-in enabledPublic Access enabledCan create/modify usersCan create/modify groupsUser administrative rightsSystem administrative rightsI'm looking to know which users have these rights given to their account?Can create/modify usersCan create/modify groupsUser administrative rightsSystem administrative rightsAnyone have a report that will show these items?MS SQLRegards,Dragan

Find more posts tagged with

Comments

eLink User

Message from Nair, Krishnankutty N. via eLinkIf your database is oracle you are in luck.Oracle has a function thatcan detect a Bit on/OFFThe permissions in livelink are bitmasks .To see if user has login privsthis query will sufficeThis query will give you all users that have login in their profileselect id,groupid,name,FirstName,MIDDLENAME,LastName from kuaf where type=0 and deleted=0 and BitAnd(userprivileges, 15) = 15 2062 is the BitMask for Public Access46 is the BitMask for CCMU78 is the BitMask for CCMG30 is the BitMask for UA270 is the BitMask for SAI am sure in MSSQLserver there ought to be something that can detect thepresence of these bits. -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, April 07, 2006 10:45 AMTo: eLink RecipientSubject: Report to show which users have rights given to their account?Report to show which users have rights given to their account?Posted by Jichici, Dragan on 04/07/2006 11:39 AMWhen a user is created they are given the following options:Log-in enabledPublic Access enabledCan create/modify usersCan create/modify groupsUser administrative rightsSystem administrative rightsI'm looking to know which users have these rights given to theiraccount?Can create/modify usersCan create/modify groupsUser administrative rightsSystem administrative rightsAnyone have a report that will show these items?MS SQLRegards,Dragan[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

eLink User

Message from Nair, Krishnankutty N. via eLinkQuery Incorrect/corrected versionselect id,groupid,name,FirstName,MIDDLENAME,LastName,userprivileges from kuaf where type=0 and deleted=0 and BitAnd(userprivileges, 15) = 15 -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, April 07, 2006 11:10 AMTo: eLink RecipientSubject: RE Report to show which users have rights given to theiraccount?RE Report to show which users have rights given to their account?Posted by eLink on 04/07/2006 12:09 PMMessage from Nair, Krishnankutty N. via eLinkIf your database is oracle you are in luck.Oracle has a function thatcan detect a Bit on/OFFThe permissions in livelink are bitmasks .To see if user has login privsthis query will sufficeThis query will give you all users that have login in their profileselect id,groupid,name,FirstName,MIDDLENAME,LastName from kuaf where type=0 and deleted=0 and BitAnd(userprivileges, 15) = 15 2062 is the BitMask for Public Access46 is the BitMask for CCMU78 is the BitMask for CCMG30 is the BitMask for UA270 is the BitMask for SAI am sure in MSSQLserver there ought to be something that can detect thepresence of these bits. -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, April 07, 2006 10:45 AMTo: eLink RecipientSubject: Report to show which users have rights given to their account?Report to show which users have rights given to their account?Posted by Jichici, Dragan on 04/07/2006 11:39 AMWhen a user is created they are given the following options:Log-in enabledPublic Access enabledCan create/modify usersCan create/modify groupsUser administrative rightsSystem administrative rightsI'm looking to know which users have these rights given to theiraccount?Can create/modify usersCan create/modify groupsUser administrative rightsSystem administrative rightsAnyone have a report that will show these items?MS SQLRegards,Dragan[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Report to show which users have rights given to theiraccount?https://knowledge.opentext.com/knowledge/livelink.exe/open/5336993Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Drane_Matthew

Message from Drane, Matt <mdrane@hasbro.com> via eLink

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

This should work on MSSQL:

It filters only to those that have one of the following: Create Users, Create Groups, Administer Users, System Admin

select LLUser.LastName,
LLUser.FirstName,
LLUser.name as [UserID],
Department.Name as [Department],
(CASE WHEN (LLUser.UserPrivileges/1) %% 2 = 1 then 'Yes' else ' ' END)
                                                 As [Login enabled],
(CASE WHEN (LLUser.UserPrivileges/2048) %% 2 = 1 then 'Yes' else ' ' END)
                                                 As [Public Access],
(CASE WHEN (LLUser.UserPrivileges/32) %% 2 = 1 then 'Yes' else ' ' END)
                                                 As [Create Users],
(CASE WHEN (LLUser.UserPrivileges/64) %% 2 = 1 then 'Yes' else ' ' END)
                                                 As [Create Groups],
(CASE WHEN (LLUser.UserPrivileges/16) %% 2 = 1 then 'Yes' else ' ' END)
                                                 As [User Admin],
(CASE WHEN (LLUser.UserPrivileges/256) %% 2 = 1 then 'Yes' else ' ' END)
                                                 As [System Admin]

FROM kuaf LLUser
INNER JOIN kuaf Department ON LLUser.GroupID = Department.ID

WHERE LLUser.Deleted = 0

AND
(

((convert(int,(LLUser.UserPrivileges/32)) %% 2)=1)
OR
((convert(int,(LLUser.UserPrivileges/64)) %% 2)=1)
OR
((convert(int,(LLUser.UserPrivileges/16)) %% 2)=1)
OR
((convert(int,(LLUser.UserPrivileges/256)) %% 2)=1)

)

ORDER BY LLUser.LastName, LLUser.FirstName

Dragan_Jichici

This is great!Thank you so much Matt.Regards,Dragan