If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Security

Started by dpccgf, 29 May 2014 02:34:07 PM

Previous topic - Next topic

dpccgf

Is there an easy way to find how a user has been setup and what roles/groups they have been put in in Cognos?

clayton

hi ,

Just run the following script in your content store.

SELECT      v_group.name AS group_name,                                  
         v_user.ldap_id AS user_name                              
FROM      dbo.cmreford1 AS v_group_user                                  
JOIN      (SELECT      cmid user_id,                            
                  UPPER (NAME) ldap_id                      
         FROM      dbo.cmobjprops33) v_user                        
ON         v_group_user.refcmid = v_user.user_id                               
JOIN      (SELECT      cmobjnames.cmid cmid,                            
                  UPPER(cmobjnames.NAME) name                      
         
         FROM      dbo.cmobjects, dbo.cmobjnames                        
         WHERE      cmobjects.classid IN (26, 54)                         
                  AND cmobjnames.mapdlocaleid = 96                     
                  AND cmobjects.cmid = cmobjnames.cmid) v_group                      
      ON         v_group.cmid = v_group_user.cmid