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

How to get admin access through backend

Started by lewisk, 26 Aug 2016 08:08:50 AM

Previous topic - Next topic

lewisk

I have a Cognos BI 10.2.1 installation which uses a custom Java authentication mechanism.  This mechanism is broken for reasons which we don't understand.  I have enabled Active Directory authentication, and I can log in this way.  However, the account which is created this way has only minimal permissions.

I have access to the database server, there must be a way that I can adjust the credentials of this account to give it admin rights, using the appropriate SQL statements.  However I am not familiar with the tables in the content store.  Does anyone have a suggestion for doing this?  Thanks.

smiley

Fire this against the Content Store database:
C:\Program Files\IBM\cognos\c10_64\configuration\schemas\content\databaseservertypeused\AddSysAdminMember.sql

It will add the "everyone" group back to the "System Administrators" group in BI, and give you back full control.
Grant yourself normal access right to the admin group via your preferred authentication source, and then remove the "everyone" group again.

lewisk