Print Page - restore system administrator role in cognos namespace

Title: restore system administrator role in cognos namespace
Post by: hiranb on 11 May 2010 03:03:02 PM

Hi,

I accidently deleted system administrator role in cognos namespace. Can it be restored? If so please provide info on how to restore the system admin role. Thanks for your help.

Title: Re: restore system administrator role in cognos namespace
Post by: MFGF on 12 May 2010 05:09:34 AM

Hi,

Hmmm - I didn't think it was possible to physically delete the System Administrator role. Do you mean you have removed all users and groups from it? If so, there is a script you can run:

\Program Files\Cognos\c8\configuration\schemas\content\<your content store database type>\AddSysAdminMember.sql
This will add the 'everyone' group back into the System Administrators role.
Next, go into Cognos Configuration set the 'allow anonymous access' setting of the Cognos namespace to 'True' and restart your Cognos 8 service.

Good luck!

MF.

Title: Re: restore system administrator role in cognos namespace
Post by: hiranb on 12 May 2010 11:51:43 AM

It worked. Thanks.

Title: Re: restore system administrator role in cognos namespace
Post by: nj on 26 May 2010 05:33:43 AM

Applause to this.
MFGF: continue to rule.

Title: Re: restore system administrator role in cognos namespace
Post by: willg on 26 Sep 2013 10:13:46 AM

I can confirm this still works with Cognos 10, just saved me a lot of hassle! (Be sure to stop the service before doing it though otherwise it wont work).

Title: Re: restore system administrator role in cognos namespace
Post by: simi123 on 05 Dec 2013 12:53:10 PM

Thanks to MFGF!. :)

I fixed the issue after read your post.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: hiranb on 11 May 2010 03:03:02 PM