Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: parvesh.rishi on 22 Apr 2017 01:33:40 AM

Title: User Deactivation
Post by: parvesh.rishi on 22 Apr 2017 01:33:40 AM
Dear All,
I have a monthly task of deactivating multiple users from Cognos 10.2.2 portal which I have to do manually one by one.
It is a time taking and boring process.
Hence I want to automate this task by taking help of Cognos Content Store.
I have seen tables that contain some information concerning users, groups,roles, etc.. and those tables are:
CMOBJPROPS1
CMOBJPROPS33
Now I am deleting entries from these tables but that does not affect the user on the portal.
Please suggest what could be the possible solution for this problem.
Thank you!!
Title: Re: User Deactivation
Post by: j33p2006 on 24 Apr 2017 08:01:16 AM
Have the users left the company and are no longer in the Security Namespace? MetaManager has a number of modules that will enable you to identify and remove users while retaining their content http://www.bspsoftware.com/products/metamanager/


Title: Re: User Deactivation
Post by: parvesh.rishi on 03 May 2017 04:07:14 AM
Thank you!!
But we have found a solution by deleting User entries from the Content Store Tables.
Users get deactivated but the we need to restart the service for the changes to be in effect.
Title: Re: User Deactivation
Post by: bdbits on 03 May 2017 04:03:52 PM
Wow. I cannot begin to enumerate all of the reasons why modifying the content store database like this is just a Really Bad Idea(tm).

Good luck to you.
Title: Re: User Deactivation
Post by: parvesh.rishi on 27 Jun 2017 08:23:30 AM
you are absolutely right...and this suggestion got rejected by client as well.
Now we are thinking of doing it either with scripting or cognos SDK. What do you say?
Title: Re: User Deactivation
Post by: Lynn on 27 Jun 2017 09:02:41 AM
Quote from: j33p2006 on 24 Apr 2017 08:01:16 AM
Have the users left the company and are no longer in the Security Namespace? MetaManager has a number of modules that will enable you to identify and remove users while retaining their content http://www.bspsoftware.com/products/metamanager/

Have you considered this option?
Title: Re: User Deactivation
Post by: parvesh.rishi on 28 Jun 2017 05:34:27 AM
yes..this is a nice option but we are low on budget, hence we want to do it on our own without using any third party tool.
Title: Re: User Deactivation
Post by: New_Guy on 28 Jun 2017 10:47:08 AM
Hi,
Depending on your LDAP set up and the provider, I think it is possible to create the groups in the LDAP and fix the groups on the LDAP side if the LDAP guys agree on this. And then you can use some kind of automation on the LDAP tables to remove and add the users.
Good luck
New guy
Title: Re: User Deactivation
Post by: parvesh.rishi on 29 Jun 2017 08:18:39 AM
Hello New_Guy
The problem is that we want to delete the user profiles from Cognos portal and not from the LDAP (we want those users to remain on LDAP). Thank you for the suggestion!!
Parvesh Rishi
Title: Re: User Deactivation
Post by: bensah on 18 Jul 2017 07:19:45 AM
Hi,

Please create one cognos group in the LDAP and map it to the cognos group. If you want to remove from cognos then remove it from the corresponding LDAP group. So that you will not change anything in cognos. In Cognos ,only assign the corresponding groups to corresponding folders which is one time activity.

Thanks,
Benu
Text only | Text with Images