Roles Description

[Francis aka khayman]

I am having a difficult time obtaining the docs on User Roles.

What I am trying to achieve is find out what roles to give a user so that the said user can practically administer our Cognos Connection but  the user is not a System Administrator.

If somebody can point me to the right direction, its highly appreciated.

[cognostechie]

Is there a role called 'Directory Administrators' ? if so, you might want to try that.

[MFGF]

I am having a difficult time obtaining the docs on User Roles.

What I am trying to achieve is find out what roles to give a user so that the said user can practically administer our Cognos Connection but  the user is not a System Administrator.

If somebody can point me to the right direction, its highly appreciated.

Hi,

Bear in mind that the user in question needs to have a relevant admin license before you grant them any admin capabilities.

MF.

[Raghuvir]

Hi MFGF,

Is there any way we can find out the active users in cognos and to which group do they belong ? i tried querying the CMOBJPROPS1 table nut was not able to find the list of users.

Request you to guide me with this query.

Regards

[Francis aka khayman]

check this out

http://cognosm.fm3online.com/tips-and-tricks/list-the-groups-a-user-belong-to/

[cognostechie]

Hi MFGF,

Is there any way we can find out the active users in cognos and to which group do they belong ? i tried querying the CMOBJPROPS1 table nut was not able to find the list of users.

Request you to guide me with this query.

Regards

I use this to query Content Store and it gives me perfect results:


SELECT v_user.ldap_id , v_group.name group_name

FROM cmreford1 v_group_user
JOIN-- GET USERS
(SELECT cmid user_id, UPPER(NAME) ldap_id
FROM cmobjprops33) v_user
ON v_group_user.refcmid = v_user.user_id
JOIN--GET GROUPS
(SELECT cmobjnames.cmid cmid,UPPER(cmobjnames.NAME) name
FROM cmobjects,cmobjnames, cmlocales
WHERE cmobjects.classid IN (26, 54)
AND cmobjnames.mapdlocaleid = cmlocales.mapdlocaleid
AND cmobjects.cmid = cmobjnames.cmid
AND cmlocales.locale = 'en') v_group
ON v_group.cmid = v_group_user.cmid
--where v_group.name like '%%'
--and v_user.ldap_id like '%%'
order by 1,2