User Deactivation

[parvesh.rishi]

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!!

[j33p2006]

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/

[parvesh.rishi]

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.

[bdbits]

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.

[parvesh.rishi]

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?

[Lynn]

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?

[parvesh.rishi]

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.

[New_Guy]

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

[parvesh.rishi]

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

[bensah]

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