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.
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.
Super! Thank you!